2 ms·
I'll admit to giving little thought to the legibility of my SQL - this is a quick read, with some solid tips. Do you do anything in particular to make your que
by creager 11y ago
I'll admit to giving little thought to the legibility of my SQL - this is a quick read, with some solid tips.
Do you do anything in particular to make your queries more digestible?
- ThatMightBePaul 11y agoCraig mentions this in the piece, but I'll second it: I fucking love CTE's for breaking apart ugly looking queries. They make everything significantly easy to read.
- craigkerstiens 11y agoYep, this is essentially the biggest piece. Using CTEs and having building blocks that are easy to logically follow is the single biggest thing you could do.