What aggregated SQL functions you use on a daily basis? What is diff between UNION & UNION ALL? What is cross join. Max no rows in cross join of two 3x3 tables?

Question

Accepted Answer

Aggregated SQL functions used daily include COUNT, SUM, AVG, MAX, MIN. UNION combines results from two or more SELECT statements. UNION ALL includes all rows, even duplicates. Cross join combines every row from one table with every row from another.

Aggregated SQL functions: COUNT, SUM, AVG, MAX, MIN
UNION vs UNION ALL: UNION removes duplicates, UNION ALL includes all rows
Cross join: combines every row from one table with every row from another
Max no rows in cross join of two 3x3 tables: 9x9 = 81 rows

What aggregated SQL functions you use on a daily basis? What is diff between UNION &amp; UNION ALL? What is cross join. Max no rows in cross join of two 3x3 tables?

Popular interview questions of Product Operations Analyst

What aggregated SQL functions you use on a daily basis? What is diff between UNION & UNION ALL? What is cross join. Max no rows in cross join of two 3x3 tables?