@karthiksurya2265.bsky.social
💡 SQL Tip to remember the syntax order of clauses
👉 SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY → LIMIT
Mnemonic: Some French Waiters Give Hot Orders Last
#sql
👉 SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY → LIMIT
Mnemonic: Some French Waiters Give Hot Orders Last
#sql
September 10, 2025 at 6:17 PM
💡 SQL Tip to remember the syntax order of clauses
👉 SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY → LIMIT
Mnemonic: Some French Waiters Give Hot Orders Last
#sql
👉 SELECT → FROM → WHERE → GROUP BY → HAVING → ORDER BY → LIMIT
Mnemonic: Some French Waiters Give Hot Orders Last
#sql
Keeping an updated_at column in sync isn't automatic in @postgresql.org — you need to set it up manually.
A small trigger function can handle this for you and update the timestamp every time a row changes.
One quick solution 👇
#Postgres #SQL
A small trigger function can handle this for you and update the timestamp every time a row changes.
One quick solution 👇
#Postgres #SQL
September 4, 2025 at 3:27 PM
Keeping an updated_at column in sync isn't automatic in @postgresql.org — you need to set it up manually.
A small trigger function can handle this for you and update the timestamp every time a row changes.
One quick solution 👇
#Postgres #SQL
A small trigger function can handle this for you and update the timestamp every time a row changes.
One quick solution 👇
#Postgres #SQL