What is the purpose of `RETURNING` clause in PostgreSQL DML statements? Advanced SQL DeveloperMedium Try Now
What does `WITHIN GROUP (ORDER BY col)` do with ordered-set aggregate functions like `PERCENTILE_CONT()`? Advanced SQL DeveloperMedium Try Now
What is the difference between `UNION` and `UNION ALL` in terms of performance? Advanced SQL DeveloperMedium Try Now
What does `SELECT FOR UPDATE` do in SQL and when would you use it? Advanced SQL DeveloperMedium Try Now
What is a bitmap index scan in PostgreSQL and when does the optimizer prefer it? Advanced SQL DeveloperMedium Try Now
What is the `GROUPING()` function used for in SQL with ROLLUP or CUBE? Advanced SQL DeveloperMedium Try Now
What is the purpose of `EXPLAIN (BUFFERS, ANALYZE)` in PostgreSQL? Advanced SQL DeveloperMedium Try Now
What is a materialized CTE (`WITH … AS MATERIALIZED`) vs an inlined CTE and what problem does materialization solve? Advanced SQL DeveloperMedium Try Now
What is the difference between `DATEDIFF()` in MySQL vs `age()` in PostgreSQL for date arithmetic? Advanced SQL DeveloperMedium Try Now
What is the gap between `RANK()` values and what does that indicate about tied data? Advanced SQL DeveloperMedium Try Now
