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…

SELECT INTO statement is used to copy data from one table into a new table. Syntax of SELECT INTO in SQL-…

CASE statement is used to return the value if the specified condition evaluates to True, else it returns the value of…

ISNULL(), SQL Server function returns an alternative value when an expression is NULL. Syntax of ISNULL() in SQL- ISNULL(<column_name>,<alternative_value>) Example…

Stored Procedure in SQL is a group of SQL Statements stored in the database for performing a particular task. Syntax of…

A VIEW in SQL is a virtual table showing up-to-date result-set of SQL statements.Unlike a real table, a view does not exist…

The CHECK constraint in SQL is used to limit the value that can be placed in a column or table. Example of…

The NOT NULL constraint in SQL is used to disallow the acceptance of NULL value in a column(s). A column, by default,…

The UNIQUE constraint in SQL is used to ensure that all values in a column are unique or different. Example of UNIQUE…

The aliases in SQL are used to give temporary name to a table or a column in a table. An alias is…

The DEFAULT constraint in SQL is used to set a default value for a column. Example of DEFAULT constraint creation in SQL…

The CREATE INDEX statement in SQL is used to create indexes in tables. Indexes are used for faster retrieval of records which…