EXCEPT

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736078

  More actions

  January 27, 2015 at 8:25 pm

  #75707

  Comments posted to this topic are about the item EXCEPT

• rhythmk

  SSCertifiable

  Points: 7271

  More actions

  January 27, 2015 at 9:35 pm

  #1773559

  Thanks for question.Easy +2 points 🙂

  --rhythmk
  ------------------------------------------------------------------
  To post your question use below link
  
  https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
  🙂

• January 28, 2015 at 12:04 am

  This was removed by the editor as SPAM

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  January 28, 2015 at 12:24 am

  #1773580

  Easy one. I use it a lot to test two tables (one from test and one from prod) to see if the data is equal or not.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Raghavendra Mudugal

  SSChampion

  Points: 10658

  More actions

  January 28, 2015 at 12:37 am

  #1773583

  Thank you Steve for the post, good one.

  ww; Raghu
  --
  The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

• Skanker

  Hall of Fame

  Points: 3059

  More actions

  January 28, 2015 at 2:35 am

  #1773601

  Got it wrong as did not read the question properly...that said I may have got it wrong anyway as learnt something new today. Thanks for that. 😀

• Skanker

  Hall of Fame

  Points: 3059

  More actions

  January 28, 2015 at 2:46 am

  #1773604

  I changed the query to be this

  SELECT

  Salesyear

  , complete

  , amount

  FROM

  sales

  WHERE

  customerid = 2

  EXCEPT

  SELECT

  Salesyear

  , complete

  , amount

  FROM

  sales

  WHERE

  customerid = 1

  I expected to see 2 rows but returned 1 only. Not sure why (other than me being thick).

• January 28, 2015 at 3:05 am

  This was removed by the editor as SPAM

• Skanker

  Hall of Fame

  Points: 3059

  More actions

  January 28, 2015 at 3:20 am

  #1773612

  EXCEPT[/url] Returns distinct rows by comparing the results of two queries.

  Given that the last 2 records for client 2 are the same, only one row will be returned

  thank you for this. Now read up on instead of playing. Now learnt that should read before posting!!

• RK Mandava

  SSCarpal Tunnel

  Points: 4153

  More actions

  January 28, 2015 at 7:34 am

  #1773682

  good one, thanks

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  January 28, 2015 at 9:48 am

  #1773743

  Except is a really fast way of accomplishing it, too. When compared with the other methods I've tried, this is clearly the fastest.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions

• John Hanrahan

  Hall of Fame

  Points: 3825

  More actions

  January 28, 2015 at 10:20 am

  #1773754

  I never use this. Thanks for the new "learnt".

• Thomas Abraham

  SSChampion

  Points: 10761

  More actions

  January 28, 2015 at 10:28 am

  #1773760

  Thanks for the question Steve. Liked it a lot.

  [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
  Connect to me on LinkedIn

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  January 28, 2015 at 10:34 am

  #1773764

  Easy one for me this time, thanks. I use this in a few of my queries.

• sqlnaive

  SSCoach

  Points: 17437

  More actions

  February 19, 2015 at 12:24 am

  #1778537

  Easy one for me. But good basic question. 🙂