A database is a organized collection of data. Data is stored in relational database in form of tables. To create, retrieve, update and delete from… [Read More]
Introduction to SQL
SQL is a language which is used to interact with relational database management system. Before we learn what is a SQL and what we can… [Read More]
SQL SELECT TOP Statement
SQL SELECT TOP statement returns the specified number of records starting from the top of the table. The SQL SELECT TOP Syntax Selects top n… [Read More]
SQL SELECT COUNT
The count() function returns the number of rows that matches the given condition. SQL COUNT() function Syntax SELECT COUNT (column_name) FROM table_name WHERE condition; SQL… [Read More]
SQL SELECT Statement
Select statement is used to fetch data from relational database. A relational database is organized collection of data. As we know that data is stored… [Read More]
UNIQUE Constraint in SQL
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]