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

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

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

The distinct keyword is mainly  used with the Select statement  in order to get  unique values from the desired table. Distinct removes all the redundant records while...

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

This constraint is used to uniquely define an identify any entry in the table. There are certain conditions like a primary key value can’t...

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 the pattern...

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...

Follow us on Facebook

Facebook Page Loading...