Sql Programming Tutorials, Guides & Best Practices

• 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
RIGHT JOIN departments
ON employees.department_id = departments.department_id;

The FULL JOIN combines the results of both LEFT JOIN and RIGHT JOIN. It returns all records when there is a match in either the left or right table.