UNIQUE Constraint enforces a column or set of columns to have unique values. If a column has a Unique constraint, it means that particular column… [Read More]
DEFAULT Constraint in SQL
The DEFAULT constraint provides a default value to a column when there is no value provided while inserting a record into a table. Lets see… [Read More]
NOT NULL Constraint in SQL
NOT NULL constraint makes sure that a column does not hold NULL value. When we don’t provide value for a particular column while inserting a… [Read More]
Group By clause in SQL
Group by clause is used for grouping the similar data after fetching it from tables(s). In this tutorial we will learn how to use GROUP… [Read More]
LIKE Clause in SQL
Like clause is used for fetching similar values from table(s). For e.g. you may want to fetch all the names from a table that starts… [Read More]
SQL SELECT DISTINCT Statement
SELECT DISTINCT Statement is used to fetch unique records from a table. It only returns distinct values in the result. Lets say we have a… [Read More]
SQL ORDER BY Clause
We know that SQL SELECT Statement returns the rows in no particular order. With the help of ORDER BY clause, we can order the rows… [Read More]
DELETE Query in SQL
Delete Query is used for deleting the existing rows(records) from table. Generally DELETE query is used along with WHERE clause to delete the certain number… [Read More]
UPDATE Query in SQL
Update Query is used for updating existing rows(records) in a table. In last few tutorials we have seen how to insert data in table using… [Read More]
SQL WHERE Clause
Where clause is used to fetch a particular row or set of rows from a table. This clause filters records based on given conditions and… [Read More]