Decision-ready insights on product engineering and data systems.

UNION clause

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

JOIN clause

JOIN clause is used to combine two or more tables data by using a common column. It is often used with other clauses such as 'SELECT', 'FROM', 'HAVING' and 'ORDER B…

ORDER BY clause

ORDER BY clause is used to sort the data in ascending or descending order based on column(s). It is often used with other clauses such as 'SELECT', 'FROM', 'HAVING'…

HAVING clause

HAVING clause is always used with "GROUP BY" clause to filter the data that has already been grouped by the "GROUP BY" clause.

GROUP BY clause

GROUP BY clause is used to group and summarize the data based on column(s) and generally combined with aggregate functions such as SUM, AVG, COUNT, MIN and MAX etce…

WHERE clause

WHERE clause is used to specify condition(s) to filter data in the database. It is often used with other clauses such as 'SELECT', 'FROM' and 'ORDER BY' etc. to ret…

FROM clause

FROM clause is used to specify table name(s) from where data will be retrieved. It is often used with other clauses such as 'SELECT', 'WHERE' and 'ORDER BY' etc. to…

SELECT clause

SELECT clause is used to retrieve/get data from table(s) in the database. It is often used with other clauses such as 'FROM', 'WHERE' and 'ORDER BY' etc. to specify…

SQL Clauses

INSERT INTO statement