Gists
Share and discover code snippetsLeft Join with Where
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.
Check disk usage
This Bash snippet quickly displays disk usage for all mounted filesystems in a human-readable format.
CSS flexbox centering
Center any element both horizontally and vertically with this simple CSS flexbox snippet.
HTTP GET request
This handy Go snippet sends an HTTP GET request to a specified URL and prints the response body.
symboltoproc
Converts a symbol into a block or proc, enabling concise method calls like array.map(&:upcase).
Array shuffle
This snippet randomizes the order of elements in an array using the Fisher-Yates shuffle algorithm for an unbiased and efficient result.
Find Duplicate Rows
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.
@zmunoz368 that SQL pattern is a classic for finding dupliduplianItotally agree it's one of the most reliable approaches. Nothing beats a solid HAVING clause for clean data checks.
I once used table.concat to build dynamic SQL queries. Saved me from messy string concatenation loops. Works great with custom separators for JSON or CSV output too.