SQLServerLog.com - Database Tips, Techniques and Tutorials

0

SQL UNION ALL Operator

SQL UNION ALL operator is used to combine the results of two or more SELECT statements. Each SELECT statement within the UNION ALL must have the same number of columns and all columns should have...

0

SQL UNION Operator

SQL UNION operator is used to combine the results of two or more SELECT statements. Each SELECT statement within the UNION must have the same number of columns and all columns should have same order...

0

SQL CROSS JOIN

SQL CROSS JOIN returns all records where each row from the first table is combined with each row of the second table. CROSS JOIN returns the Cartesian product of the tables involved in join if...

0

SQL FULL JOIN

SQL FULL JOIN returns all the rows from the left table and all the rows from the right table. If there are no matching values in either of the tables then non-matching values returned as NULL....

0

SQL RIGHT JOIN

SQL RIGHT JOIN returns all the rows from the right table mentioned with the RIGHT JOIN clause. If there are no matching rows in left table then output rows will return NULL values. Syntax SELECT...

0

SQL LEFT JOIN

SQL LEFT JOIN returns all the rows from the left table mentioned with the LEFT JOIN clause. If there are no matching rows in right table then output rows will return NULL values. Syntax SELECT...