Re:Ask HN: Does anyone else think SQL needs help?
by grvdrm on Monday September 12, 2022 @08:49AM
(#32809347)
The recursive stuff is pretty cool. In general, I like CTEs a way to break queries into pieces to improve readability and understanding (among other improvements).
Also, integrating aggregate functions along with row_number() and similar functions to perform more complex work with less code.
Also, integrating aggregate functions along with row_number() and similar functions to perform more complex work with less code.