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,634 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 | 879 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,467 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,556 reads
   Items 1 to 5 of 5   
t-sql (4)    
blogs (1)    
coalesce (1)    
count (1)    
isnull (1)    
union (1)