Author: B D

A sub-query or Inner query or Nested query is a query within another SQL Server query and embedded within the WHERE clause. A subquery is used to return data that will be used in the main…

The MS SQL Server Joins clause is used to combine records from two or more tables in a database. A JOIN is a means for combining fields from two tables by using…

The MS SQL Server DISTINCT keyword is used in conjunction with the SELECT statement to eliminate all the duplicate records and fetching only unique records. There may be a situation when you…

The SQL Server GROUP BY clause is used in collaboration with the SELECT statement to arrange identical data into groups. The GROUP BY clause follows the WHERE clause in a SELECT statement…

The MS SQL Server ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns. Some database sort query results in ascending order…

The MS SQL Server LIKE clause is used to compare a value to similar values using wildcard operators. There are two wildcards used in conjunction with the LIKE operator − The percent…

The MS SQL Server WHERE clause is used to specify a condition while fetching the data from a single table or joining with multiple tables. If the given condition is satisfied, only…

The SQL Server DELETE Query is used to delete the existing records from a table. You have to use the WHERE clause with the DELETE query to delete selected rows, otherwise, all…

The SQL Server UPDATE Query is used to modify the existing records in a table. You can use the WHERE clause with the UPDATE query to update selected rows otherwise all the…

SQL Server SELECT statement is used to fetch the data from a database table which returns data in the form of a result table. These result tables are called result-sets. Syntax Following is…