4 ms·
I go back and forth with conjunction at the end or beginning of the line. At the end you get to line up column names, at the beginning it makes it easier to com
by rubyfan 10y ago
I go back and forth with conjunction at the end or beginning of the line. At the end you get to line up column names, at the beginning it makes it easier to comment out or remove the line and basically contains the intended logic on a single line.
I think I usually end up with the later because I think it makes more sense.
- berntb 10y agoWhy not this? WHERE A AND B AND C Or better, this? You can comment out any part easily. WHERE 1 AND A AND B AND C (With keywords capitalized, as g-d intended. :-) Or not.)
- nerdponx 10y agoI like the "WHERE 1" trick, thanks!
- bhrgunatha 10y agoI have the same problem and also with where to put the commas separating columns names. You can't win the game though. Sometimes you want to remove/comment out the first line, sometimes the last, sometimes one in the middle.