Technology – Distinct Vs Group By in SQL Server
While it is tempting to select the fastest method, the truth is that DISTINCT is often the fastest option. There are advantages and disadvantages to each, but using both methods is not always better. Luckily, modern tools make this comparison easy. Tools like dbForge SQL Complete can calculate aggregate functions and DISTINCT values in a … More Technology – Distinct Vs Group By in SQL Server