Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag DISTINCT Rss

   Items 1 to 5 of 5   
 

COUNT, COALESCE, ISNULL, DISTINCT

By Steve Jacobs 2013/11/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,576 reads

Union Forcing Distinct

The use of union would seem to force a distinct in each of the select statements being unioned. The use multiple unions, with mixed union and union all clauses, seems to cause haphazard results.  Read more...
By Clyde Merrell 2013/05/14 | Source: SQLServerCentral.com | Category: union
Rating: |  Discuss |   Briefcase | 869 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,426 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 | 4,313 reads
   Items 1 to 5 of 5   
 
Tags
t-sql (4)    
blogs (1)    
coalesce (1)    
count (1)    
isnull (1)    
union (1)