Click here to monitor SSC
SQLServerCentral is supported by Redgate
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,692 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 | 889 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,528 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,862 reads
   Items 1 to 5 of 5   
t-sql (4)    
blogs (1)    
coalesce (1)    
count (1)    
isnull (1)    
union (1)