SqlZap

My activity..

Use IS DISTINCT FROM for NULL-safe comparisons: Unlike <>, it treats NULL as a comparable value: NULL vs NULL → not different NULL vs a value → different two different values → different Supported by PostgreSQL and several other SQL databases.

SQL tip 💡 Use a window frame to calculate a running total without collapsing rows:

Use FILTER to calculate multiple conditional aggregates cleanly:

You can use NULLIF() to prevent division-by-zero errors. When users is 0, NULLIF(users, 0) returns NULL, so the query returns NULL instead of failing.

This sample code shows how to restore the MYSQL backup from the zipped file:

This is how you can set aliases for columns in SELECT

You can also filter JSON like you can in SQL.

Here is one incredible sample query on how to search in the MYSQL JSON field. Assuming you have a table called users with a JSON column named profile, and you want to find all users where the age field inside the JSON object is equal to 30:

Here is the version with a subquery. I like the version that uses "WITH" more.