DROP TABLE, TRUNCATE TABLE AND DELETE IN SQL Key Word Syntax Explanation DROP TABLE DROP TABLE <table_name>; DROP TABLE is…

ALTER TABLE IN SQL ALTER TABLE statement is used to add, delete, or modify columns and add or drop constraints…

INSERT INTO INSERT INTO statement is used to insert values or records into table in SQL. Records in a table…

UPDATE UPDATE statement is used to update the existing records in a table in SQL. Syntax- UPDATE <table_name> SET column1…

SELECT SELECT statement is used to access records from a database. The table which stores the record returned by the…

SELECT DISTINCT The SQL DISTINCT command is used with SELECT key word to retrieve only distinct or unique values. Syntax-…

WHERE WHERE clause in SQL is a data manipulation language (DML) statement. WHERE clause is used in filter the records…

AND OPERATOR IN SQL The AND operator displays a record if all the conditions separated by AND are TRUE. Syntax- SELECT…

ORDER BY CLAUSE ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending…

A field having NULL value is one that has been left blank during record creation, NULL value field means field with no…

SELECT TOP SELECT TOP clause is used to specify the number of records to return from top of the table. Syntax…

MIN() AND MAX() MIN() function returns the smallest value of the selected column Syntax – SELECT  MIN(ColumnName) FROM <TableName> WHERE<condition> ;    Example- SELECT  MIN(Price)…

COUNT() function returns the number of rows that matches a specified condition. Syntax – SELECT  COUNT(ColumnName) FROM <TableName> WHERE<condition> ;    Example- SELECT …

LIKE operator is used in a WHERE clause to search for a specified pattern in a column. SQL LIKE Operator uses…

WILDCARD  characters are used to substitute one or more characters in a string and used with LIKE operator  which is used…

IN operator is used to reduce use of multiple OR conditions by specifying multiple values in WHERE clause. Syntax of IN…

BETWEEN operator fetches the records from the table within the range specified in the query. Between Operator includes the starting and…

BACKUP DATABASE is used to create full backup of an existing SQL SERVER database. Syntax of BACKUP DATABASE in SQL –…

CONSTRAINTS are used to create rules for data in a table to limit the type of data that can be stored…

JOIN clause combine rows from two or more tables, based on a common field between them. There are five types of JOIN, defined…