SQL

To get a specific number of records TOP clause is used. It is helpful when the data is large because...

To check weather there is a null value or not, we use IS NULL or IS NOT NULL operators. IS NULL...

The DELETE statement is used to delete the existing record/records in a table. Syntax: DELETE FROM table_name WHERE condition; DEMO...

The UPDATE statement is used to modify/update the existing record in table. Syntax: UPDATE table_name SET column1 = value, …....

To filter the records just like WHERE clause, HAVING clause is used.  HAVING clause is used with aggregate functions because with...

Select statement is used to fetch data from a table. Mainly the data is fetched by two ways using select...

ORDER BY keyword is used to order the record in ascending or descending order. To order the record in in...

Where clause is used to apply condition on to filter the records. It is used to get the desired record....

Select statement is used to fetch data from a table. Mainly the data is fetched by two ways using select...

INSERT INTO statement is used to add data into the table. Data in the table can be inserted into two...