I’d heard tell of the “EXCEPT clause,” but this is my first time seeing it. Isn’t it beautiful? I have wished before for such a function, but I didn’t expect it to look so clean on the page. 300 more words
Tags » GROUP BY
I started out my morning delightfully forgetful yesterday’s research mission.
As I fed my cats, made coffee, drove to work, and began settling into my day, I intermittently listened (and re-listened) to the first third of Episode 29 of… 332 more words
Do you know that the content of the GROUP BY clause can be derived from the rest of the clauses in SELECT statement? 386 more words
Question: Can a Select statement have HAVING clause and no GROUP BY?
I was first asked this question about 20 years ago and I have to admit I did not provide the right answer which seemed to be very counter intuitive. 108 more words