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

Content with tag Subquery Rss

   Items 1 to 8 of 8   
 

Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.  Read more...
By Jeff Moden 2014/06/06 (first published: 2012/03/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,797 reads

The Subquery

By malls reddy 2013/05/09 | Category: subquery
Rating: (not yet rated) |  Discuss |   Briefcase | 2,143 reads

Comparing an inner join vs a subquery

I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing...  Read more...
By Kenneth Fisher 2013/05/08 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,466 reads

SubQuery

By Chirag Patel 2013/03/08 | Category: subquery
Rating: (not yet rated) |  Discuss |   Briefcase | 2,253 reads

SubQuery

By Chirag Patel 2013/01/11 | Category: subquery
Rating: (not yet rated) |  Discuss |   Briefcase | 2,636 reads

Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.  Read more...
By Jeff Moden 2014/06/06 (first published: 2012/03/29) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 21,797 reads

SubQuery

By Jason Brimhall 2011/09/19 | Category: subquery
Rating: (not yet rated) |  Discuss |   Briefcase | 2,987 reads
   Items 1 to 8 of 8   
 
Tags
t-sql (7)    
blogs (1)    
except (1)    
group by (1)    
having (1)    
inner join (1)    
not in (1)    
three valued logic (1)