Gists

Share and discover code snippets
29 gists

Top N per group

📝 SQL
This SQL snippet uses a window function (like ROWNUMBER) to fetch the top N records from each category or group in your dataset.
njackson66 njackson66
20d ago

Find Duplicate Values

📝 SQL
This query uses GROUP BY and HAVING to identify duplicate values in a column for quick data quality checks.
silvakelly249 silvakelly249
22d ago

Left Join with Where

📝 SQL
Use a LEFT JOIN with a WHERE clause to filter results from the right table while still preserving all rows from the left table that don't have matches.
mike46591 mike46591
22d ago

Find Duplicate Rows

📝 SQL
This SQL snippet identifies rows that appear more than once in a table by grouping columns and filtering with a HAVING clause count greater than one.
psilva774 psilva774
22d ago
+