3 ms·
This doesn’t totally solve the issue of SELECT’ing first then filtering, but for complex queries I’ve found CTEs very useful (whenever the database/SQL dialect
by mdcurran 3y ago
This doesn’t totally solve the issue of SELECT’ing first then filtering, but for complex queries I’ve found CTEs very useful (whenever the database/SQL dialect supports it).
- icedchai 3y agoWhat I usually do is start with "select *", get the joins and where clause down, then refine the select.