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.
Replying to @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.)
1:42 PM - 26 Oct 2019
0 replies
0 retweets
2 likes
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.
