Premium
SQL Snippets.

Extract Data Using SQL Regular Expressions

Utilize SQL's regular expression functions to parse, validate, or extract specific patterns from string data, perfect for complex data cleaning and transformation.

Perform Basic Full-Text Search with LIKE

Discover how to perform simple full-text searches in SQL using the LIKE operator and wildcards (%) to find records matching partial strings within text fields.

Retrieve Related Data with LEFT JOIN

Master how to use LEFT JOIN to retrieve records from one table along with all matching records from another, including cases where no match exists in the second table.

Count Distinct Values Per Group with HAVING

Learn to count the number of unique occurrences of a field within different groups using GROUP BY and COUNT(DISTINCT ...), filtering results with HAVING.

Delete Duplicate Rows Keeping First Occurrence

Efficiently remove duplicate entries from your database table based on specific columns in MySQL, ensuring only one unique record remains for each set of duplicates.

Perform Conditional Aggregation with CASE WHEN in SQL

Learn how to use CASE WHEN expressions within aggregate functions (SUM, COUNT) to perform conditional counting or summing in a single SQL query, generating flexible reports.

Find Records in One Table Not Present in Another (Anti-Join)

Discover how to identify records in a primary table that do not have a corresponding entry in a related table using a LEFT JOIN with an IS NULL condition, crucial for data integrity checks.

Retrieve the Nth Highest Value Using a Correlated Subquery

Learn to find the Nth highest value in a dataset, such as the 3rd highest salary, using a SQL correlated subquery without relying on window functions or pagination clauses.

Combine Result Sets from Multiple Queries with UNION ALL

Efficiently merge the results of two or more SELECT statements into a single result set using the UNION ALL operator, useful for combining similar data from different tables.

Rank Records within Groups using Window Functions

Learn to use SQL window functions like ROW_NUMBER() and RANK() to assign ranks to records within specific groups, perfect for leaderboards or top-N queries.

Perform an UPSERT Operation with ON DUPLICATE KEY UPDATE (MySQL)

Master the MySQL UPSERT pattern to either insert new rows or update existing ones if a unique key conflict occurs, ensuring data integrity efficiently.

Query Hierarchical Data with Recursive Common Table Expressions

Discover how to traverse and query tree-like or hierarchical data structures (e.g., organizational charts, categories) using powerful SQL Recursive CTEs.