timscyclingblog.wordpress.com
SQL Server / Oracle: DISTINCT or GROUP BY
Firstly, sometimes sticking in a DISTINCT is quick and easy, but so easily missed when reading the SQL and also conversely the group by can be pretty long if there are a lot of columns selected. Fi…