SQL

Comments are hints that a programmer add to explain the statements and make it more understandable. It is also used...

SELECT DISTINCT statement is used to fetch only the distinct (different) data from a table. Syntax: SELECT DISTINCT column1, column2...

The SELF JOIN joins the table with itself. Syntax: SELECT column_name(s) FROM table A, table B WHERE condition; Here A and B...

The FULL (OUTRE) JOIN keyword returns matching values from both tables. Syntax: SELECT column_name(s) FROM left_table FULL OUTER JOIN right_table ON left_table.column_name...

The RIGHT JOIN keyword returns all the records from the right table and matching records from the left table. Syntax: SELECT...

The LEFT JOIN keyword returns all the records from the left table and matching records from the right table. Syntax: SELECT...

Alias is the temporary name given to the column or to the table for better understanding.  Alias can only be...

To select the values within a selected range BETWEEN operator is used. The values can be numbers, text, or dates....

The INNER JOIN keyword returns matching values from both tables. Syntax: SELECT column_name(s) FROM left_table INNER JOIN right_table ON left_table.column_name = right_table.column_name;...

JOIN clause is used to combine two or more tables, based on a related column between them. Types of joins:...