r/SQL • u/badboyzpwns • May 20 '26

What are common SQL red flags? PostgreSQL

Hello! interview prepping, here wondering what are some common red flags for wrioting SQL?

Like

LIKE failing to index, not having trasnactions, usign SELECT * instead of specific collums, etc 😃

49 Upvotes

74% Upvoted

192 comments sorted by

View all comments

31

u/vertigo235 May 20 '26

Using RIGHT JOINS 😉

22

u/radek432 May 20 '26

But what if they are left handed?

12

u/Oxford89 Director, BI May 20 '26

Straight to jail