ALL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » SQLServerCentral.com Announcements » ALL

25 posts, Page 3 of 3

«««1 2 3

ALL

Rate Topic

Display Mode

Topic Options

Author

Message

Anipaul

Posted Tuesday, July 01, 2008 7:24 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 6:03 AM
Points: 4,786, Visits: 1,335

Nice questions ......

Post #526604

Balachandra

Posted Monday, March 16, 2009 1:45 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, June 13, 2012 1:23 AM
Points: 2,162, Visits: 170

Hi All

I am not sure wichi is correct answer. Beacuse the same question is repeted twice.

1st time i entered as 0 and answer was wrong.
2nd time i entered as 1 still anser was wrong saying it is 0

is this a valid question ?

Post #676303

Hugo Kornelis

Posted Monday, March 16, 2009 2:44 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 11:02 AM
Points: 5,233, Visits: 7,031

Balachandra (3/16/2009)

Hi Balachandra,

You have made a small reading mistake. The same question is not repeated twice; there is one small but important difference. The "first" question uses ANY, whereas the "second" (this) question uses ALL. These two keywords modify the meaning of the subquery in different ways; for that reason the question with ANY had 1 as the correct answer, and the question with ALL has 0 as the correct answer.

Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Post #676316