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…

INNER JOIN clause select all the records from both the tables when there are the values matching between the specified columns.…

LEFT JOIN/LEFT OUTER JOIN clause select all the records from left table(table1) and the matching records from the right table(table2). Syntax…

RIGHT JOIN/RIGHT OUTER JOIN clause select all the records from right table(table2) and the matching records from the left table(table1). Syntax…

FULL JOIN/FULL OUTER JOIN clause returns all the records when there is a match in left(table1) or right(table2) Syntax of FULL…

SELF JOIN is a regular join used to join the table with itself. Syntax of SELF JOIN in SQL- SELECT <column_name(s)> FROM <table1>…

GROUP BY clause in SQL statements is used to group the result-set by one or more columns that have the same…

HAVING statement is used to filter the groups in result-set based on condition. HAVING clause is used after the GROUP BY…

EXISTS  is a boolean operator which returns TRUE if the subquery returns single or multiple records else it gives a false…

ANY and ALL operator is used to perform a comparison between a single column value and a range of other…