Writing more legible SQL(craigkerstiens.com)
craigkerstiens.com
Writing more legible SQL
http://www.craigkerstiens.com/2016/01/08/writing-better-sql/
1 comments
Craig 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.
I fucking love CTE's for breaking apart ugly looking queries. They make everything significantly easy to read.
Yep, 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.
Do you do anything in particular to make your queries more digestible?