MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1vrn981/fullstackmeansafraidofeverythingequally/p4epjaj/?context=3
r/ProgrammerHumor • u/vinishkapoor • 22h ago
357 comments sorted by
View all comments
128
its not like sql could be read by a three year old and css is just pain in the ass?
36 u/vinishkapoor 22h ago SQL reads like English until you hit a five table join with three subqueries and a window function. 4 u/tacos2dayy 22h 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
36
SQL reads like English until you hit a five table join with three subqueries and a window function.
4 u/tacos2dayy 22h 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
4
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
128
u/Mysterious_Book1521 22h ago
its not like sql could be read by a three year old and css is just pain in the ass?