Twitter | Pretraživanje | |
RhodiumToad
SQL style tip: treat "SELECT DISTINCT" as one keyword that happens to have a space in it. Never put a newline before DISTINCT, and never put an open paren directly after it. When using COUNT(DISTINCT ...), if you absolutely need a paren, then always have a space before it.
Reply Retweet Označi sa "sviđa mi se" More
Christian Kruse 26. lis
Odgovor korisniku/ci @RhodiumToad @tapoueh
Exception: SELECT DISTINCT ON… 😉
Reply Retweet Označi sa "sviđa mi se"
RhodiumToad 26. lis
Odgovor korisniku/ci @cjk101010 @tapoueh
Not an exception. Still best to treat "SELECT DISTINCT ON (list)" as being a single keyword. (Or better yet, avoid using it entirely.)
Reply Retweet Označi sa "sviđa mi se"
Lukas Eder 27. lis
Odgovor korisniku/ci @RhodiumToad
You talk about formatting. I've spent so much time explaining to people that semantically, they are quite... distinct.
Reply Retweet Označi sa "sviđa mi se"