Decision-ready insights on product engineering and data systems.

INTERSECT operator

INTERSECT operator is used to retrieve the matching rows from two or more SELECT statements. It returns only distinct rows as result.

UNION ALL operator

UNION ALL operator is used to combine/merge the result of multiple SELECT statements into a single result by keeping duplicate rows.

UNION operator

UNION operator is used to merge the result of multiple SELECT statements into a single result by eliminating duplicate rows.

SQL Logical operators

SQL Comparison operators

SQL Arithmetic operators

SQL Operators

DISTINCT clause

DISTINCT clause is used to eliminate the duplicate rows from the result.

TOP clause

TOP clause is used to fetch specified number or percentage of rows from a table.

UNION ALL clause

UNION ALL clause is used to combine/merge the result of multiple SELECT statements into a single result by keeping duplicate rows.