# EXCEPT 2

• Comments posted to this topic are about the item EXCEPT 2

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

Ron

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

Am I missing something?

Igor Micev,My blog: www.igormicev.com

• Igor Micev (3/2/2014)

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

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?

• Carlo Romagnano (3/2/2014)

Igor Micev (3/2/2014)

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

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!

• Easy one, thanks.

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

• KWymore (3/2/2014)

Carlo Romagnano (3/2/2014)

Igor Micev (3/2/2014)

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

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.

• 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.

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...

• 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.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

• 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.

• KWymore (3/2/2014)

Carlo Romagnano (3/2/2014)

Igor Micev (3/2/2014)

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

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!

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

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

• 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....

• 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...

• Ron, I always enjoy your QotDs - thanks!

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