4 ms·
It's relational algebra, plus relational calculi. > Fundamentally, SQL lacks meaningful abstraction My RDBMS course at college was really hardcore and SQL cod
by nextos 4y ago
It's relational algebra, plus relational calculi.
> Fundamentally, SQL lacks meaningful abstraction
My RDBMS course at college was really hardcore and SQL code answers for exam questions were enormous.
One neat trick they didn't teach us, but still perfectly legal SQL:1999, is to use WITH recursive constructs.
This way you can decompose very complex queries into simple ones, that can tested independently.
- grvdrm 4y agoThe 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.