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   


By Steve Jacobs 2013/11/07 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 2,674 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: | Category: union
Rating: |  Discuss |   Briefcase | 886 reads

SQL DISTINCT on Multiple Columns

Learn the basic usage of DISTINCT in this article.  Read more...
By Sarvesh Singh 2011/02/08 | Source: | Category: distinct
Rating: |  Discuss |   Briefcase | 22,510 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: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 4,780 reads
   Items 1 to 5 of 5   
t-sql (4)    
blogs (1)    
coalesce (1)    
count (1)    
isnull (1)    
union (1)