Click here to monitor SSC
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 | 3,322 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,538 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,022 reads
   Items 1 to 3 of 3