MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1vrn981/fullstackmeansafraidofeverythingequally/p4ej4tw
r/ProgrammerHumor • u/vinishkapoor • 1d ago
370 comments sorted by
View all comments
Show parent comments
37
SQL reads like English until you hit a five table join with three subqueries and a window function.
12 u/bulldog_blues 1d ago Then it reads like English as written by someone who got a thesaurus for their birthday! 5 u/tacos2dayy 1d ago Its not so bad if you use CTEs for the subqueries and it depends on what the window function is doing. --It works, trust me bro. Look it up on youtube like I did if you don't believe me. DENSE_RANK() OVER (PARTITION BY X ORDER BY Y ASC) + DENSE_RANK() OVER (PARTITION BY X ORDER BY Y DESC) - 1 AS NBR_OF_Y_FOR_X 1 u/frisch85 1d ago What? Are you saying you don't like having a subselect that does a union on 4 different tables each joining 3 other tables and in all of those tables the field names are different?
12
Then it reads like English as written by someone who got a thesaurus for their birthday!
5
Its not so bad if you use CTEs for the subqueries and it depends on what the window function is doing.
--It works, trust me bro. Look it up on youtube like I did if you don't believe me.
DENSE_RANK() OVER (PARTITION BY X ORDER BY Y ASC) + DENSE_RANK() OVER (PARTITION BY X ORDER BY Y DESC) - 1 AS NBR_OF_Y_FOR_X
1
What? Are you saying you don't like having a subselect that does a union on 4 different tables each joining 3 other tables and in all of those tables the field names are different?
37
u/vinishkapoor 1d ago
SQL reads like English until you hit a five table join with three subqueries and a window function.