EXCEPT 2

  • Ron McCullough

    SSC Guru

    Points: 63877

    Comments posted to this topic are about the item EXCEPT 2

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Igor Micev

    SSC-Dedicated

    Points: 33109

    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    Igor Micev,
    My blog: www.igormicev.com

  • Carlo Romagnano

    SSC-Insane

    Points: 21987

    Igor Micev (3/2/2014)


    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    +1

    But where is EXCEPT-1?

    Why, if the qotd is identical to that of 2014/02/26, somebody got it wrong?

  • Ken Wymore

    SSCoach

    Points: 16614

    Carlo Romagnano (3/2/2014)


    Igor Micev (3/2/2014)


    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    +1

    But where is EXCEPT-1?

    Why, if the qotd is identical to that of 2014/02/26, somebody got it wrong?

    +1 Was expecting something different based on the category. Thanks for the easy points!

  • free_mascot

    One Orange Chip

    Points: 27168

    Easy one, thanks.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Raghavendra Mudugal

    SSChampion

    Points: 10658

    KWymore (3/2/2014)


    Carlo Romagnano (3/2/2014)


    Igor Micev (3/2/2014)


    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    +1

    But where is EXCEPT-1?

    Why, if the qotd is identical to that of 2014/02/26, somebody got it wrong?

    +1 Was expecting something different based on the category. Thanks for the easy points!

    me : 0; Deja vu: 1

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

  • Michael Riemer

    SSCertifiable

    Points: 5136

    Raghavendra Mudugal (3/3/2014)


    KWymore (3/2/2014)


    Carlo Romagnano (3/2/2014)


    Igor Micev (3/2/2014)


    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    +1

    But where is EXCEPT-1?

    Why, if the qotd is identical to that of 2014/02/26, somebody got it wrong?

    +1 Was expecting something different based on the category. Thanks for the easy points!

    me : 0; Deja vu: 1

    At least I am not the only one almost getting confused...

  • Hany Helmy

    SSChampion

    Points: 13488

    I guess there is something wrong with this question as it should be like follows:

    SELECT X AS 'Except'

    FROM A

    EXCEPT

    SELECT Y

    FROM B

    but maybe the author took it copy/paste from his 1st question and forgot to change the code.

  • Carlo Romagnano

    SSC-Insane

    Points: 21987

    Hany Helmy (3/3/2014)


    I guess there is something wrong with this question as it should be like follows:

    SELECT X AS 'Except'

    FROM A

    EXCEPT

    SELECT Y

    FROM B

    but maybe the author took it copy/paste from his 1st question and forgot to change the code.

    I don't think so, the answers are incompatibile, too.

  • PRAMANA.DBA

    SSCertifiable

    Points: 5507

    KWymore (3/2/2014)


    Carlo Romagnano (3/2/2014)


    Igor Micev (3/2/2014)


    Question is identical with that of 2014/02/26.

    The answer is also identical.

    Am I missing something?

    +1

    But where is EXCEPT-1?

    Why, if the qotd is identical to that of 2014/02/26, somebody got it wrong?

    +1 Was expecting something different based on the category. Thanks for the easy points!

  • Vera-428803

    SSCrazy

    Points: 2439

    Same question as 26/02/2014, same answer -> easy one, thanks :hehe:

  • Ed Wagner

    SSC Guru

    Points: 286982

    It was a nice, easy one to start the week, so thanks.

  • sneumersky

    SSCertifiable

    Points: 7667

    I keep waiting for the SQL Server database engine to add the ability to use "CORRESPONDING BY" with set difference queries such as these. Good thing I haven't held my breath....

  • Revenant

    SSC-Forever

    Points: 42467

    sneumersky (3/3/2014)


    I keep waiting for the SQL Server database engine to add the ability to use "CORRESPONDING BY" with set difference queries such as these. Good thing I haven't held my breath....

    Yeah, I wish the SQL language standard incorporated

    INSERT CORRESPONDING INTO a

    SELECT * FROM b

    Well, there is a way around it...

  • Revenant

    SSC-Forever

    Points: 42467

    Ron, I always enjoy your QotDs - thanks!

Viewing 15 posts - 1 through 15 (of 29 total)

You must be logged in to reply to this topic. Login to reply