25.8 C
Bacolod City
Saturday, November 17, 2018

SQL ORDER BY Keyword

It defines how the records are to be sorted. By default, it is to order in ascending order(ASC). If we want to sort in...

SQL UNIQUE Constraint

This unique constraint identifies each record in a table. A PRIMARY KEY constraint itself defines UNIQUE constraint. The basic difference between UNIQUE and PRIMARY...

SQL Clone Table

The SQL clone table may be used in a situation that you need an exact copy of a table and CREATE TABLE ... SELECT...

SQL Having Clause

SQL Having Clause Having clause is used to mention condition in Group based SQL functions, just like WHERE clause. It acts in the same way...

SQL GROUP BY Statement

The SQL Group by statement is used to group the results of a SELECT query based on one or more columns.   The syntax for using...

SQL Distinct Keyword

SQL Distinct Keyword The SQL Distinct Keyword is mainly used with the Select statement in order to get unique values from the desired table. Distinct removes all the...

SQL Temporary Tables

The temporary tables could be exceptionally valuable at times to keep transitory information. An essential thing that ought to be known for impermanent tables...

SQL Primary Key Constraint

SQL Primary Key Constraint This constraint is used to uniquely define an identify any entry in the table. There are certain conditions like a primary...

SQL Regular Expressions

SQL Regular Expressions Following is the table of pattern, which can be used along with REGEXP operator in a query for a selected table in the database. Pattern What...

SQL NULL Values

When SELECT command is used along with WHERE clause in order to fetch data from MySQL table of a given database, but the condition implied doesn’t have any...

SQL Join Command

Join Command is basically used to get the data from different tables using a single query into a single table. A user can use JOIN...

SQL AND & OR Operators

We can link multiple WHERE statements by AND/OR statements. AND means that all the conditions are TRUE. OR means, at least, one condition is TRUE.   For example,...

SQL ALTER Table Statement

Using ALTER Table Statement, we were able to Add, Delete or Modify Columns in an existing table. Syntax to add a column: Syntax to drop a...

SQL ORDER BY keyword

ORDER BY used to define how the records are to be sorted. By default, it is to order in ascending order(ASC). If we want to sort in...

SQL LIKE Clause

A “where” command is used when a user wants the exact result. For example, a user wants to search for the name Rajat Sharma then...

SQL WHERE Clause

SQL WHERE clause is an optional clause used to define what records are to be included in the query. We use conditional operators like...

Subscribe For Latest Updates

Signup for our newsletter and get notified when we publish new articles for free!