SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag DISTINCT Rss

Search for any content tagged distinct

   Items 1 to 3 of 3   

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.  Read more...
By Additional Articles 2017/02/23 | Source: SimpleTalk | Category: performance
Rating: (not yet rated)  Rate this |   Briefcase | 8,284 reads

SQL DISTINCT on Multiple Columns

Learn the basic usage of DISTINCT in this article.  Read more...
By Sarvesh Singh 2011/02/08 | Source: SQLServerCentral.com | Category: distinct
Rating: |  Discuss |   Briefcase | 22,545 reads

Distincting an IN subquery

This is going to be a quick oneā€¦ I keep seeing forum code (and production code) that includes the DISTINCT in...  Read more...
By Gail Shaw 2011/01/26 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 5,278 reads
   Items 1 to 3 of 3