Relational Databases Development Tutorials, Guides & Insights

• ROW_NUMBER(): Assigns unique sequential numbers.
• RANK(): Assigns ranks with gaps on ties.
• DENSE_RANK(): Ranks without gaps.
• NTILE(n): Divides rows into n groups.
• LEAD() / LAG(): Accesses next/previous rows.

SELECT column1, window_function() OVER (PARTITION BY column ORDER BY column)
FROM table;

SELECT employees.name, departments.department_name
FROM employees
FULL JOIN departments
ON employees.department_id = departments.department_id;

The CROSS JOIN returns the Cartesian product of both tables.