SELECT FUN

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by mverma4you » SELECT FUN

35 posts, Page 3 of 4

«««1 2 3 4 »»

SELECT FUN

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Thursday, April 23, 2009 9:55 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 1:47 PM
Points: 31,406, Visits: 13,722

Points awarded back and both 1 and 2 marked as correct.

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #703363

DPhillips-731960

Posted Thursday, April 23, 2009 11:13 AM

Ten Centuries

Group: General Forum Members
Last Login: Friday, August 10, 2012 6:08 PM
Points: 1,156, Visits: 801

Too Funny. I clicked the wrong box... but interesting point just the same. Thanks for the questions!

Post #703442

Arsi Salo

Posted Friday, April 24, 2009 2:13 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, March 21, 2013 7:13 AM
Points: 1,228, Visits: 190

... And now the original correct choice does not give point... Ermm

Post #703782

Hugo Kornelis

Posted Friday, April 24, 2009 2:21 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 5,231, Visits: 7,021

Arsi Salo (4/24/2009)

... And now the original correct choice does not give point... Ermm

... which is entirely correct, since the question has been changed to (emphasis mine):

"What can be the output for this code? (select all that apply)"

And as already discussed at length in this topic, the query only defines which rows to be returned and not the order, so both versions can be the output (even if only one of them actually is when you run the code).

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

Post #703786

Jamie Longstreet-481950

Posted Monday, April 27, 2009 5:57 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:57 PM
Points: 2,440, Visits: 712

When it comes to fun and humor (on SQLSERVERCENTRAL), I am very good at getting the answer wrong.

Jamie

Post #704845

Mohamed-401375

Posted Monday, April 27, 2009 12:43 PM

SSC Eights!

Group: General Forum Members
Last Login: Monday, November 26, 2012 5:36 PM
Points: 869, Visits: 96

Interesting question. Highlights the features of two clauses- UNION & ORDER BY
but the phrasing of the question was kind of misleading. That has caused lots of folks to skip the second answer. I agree with Hugo Kornelis that the question could have been phrased a little more explicitly.

Post #705221

Reginald J Ray Jr

Posted Tuesday, May 05, 2009 8:12 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 8:12 AM
Points: 17, Visits: 55

I chose #1, or maybe #2, but either one is correct, and it told me I was wrong. I know the test developer couldn't have made a mistake so I guess the computer just messed up :^)...

Post #710242

Hugo Kornelis

Posted Tuesday, May 05, 2009 8:19 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 12:12 PM
Points: 5,231, Visits: 7,021

I know the test developer couldn't have made a mistake

Hi Reginald,

Do I sense some sarcasm there? Wink

Anyway, if you selected both #1 and #2, then you should have gotten the point. If you chose one of them at random, you shouldn't - since the question (now!) specifically asks what can be the output, and asks you to "select all that apply".

Read the preceeding discussion for more information about the original phrasing of the question and why this was changed.

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

Post #710254

Jamie Longstreet-481950

Posted Tuesday, May 05, 2009 8:32 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 6:57 PM
Points: 2,440, Visits: 712

select all that apply

Steve frequently goes in and gives credit even if the user does not "select all that apply'. Take note of a qot from 4/27/09. Question says all that apply but credit was given anyway.

Perhaps it should be the case here as well?

Jamie

Post #710275

Reginald J Ray Jr

Posted Tuesday, May 05, 2009 8:48 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, February 21, 2013 8:12 AM
Points: 17, Visits: 55

That's a nice thought but not necessary - I just got 2 points credit on a different question - using totally false reasoning - so we're more than even !!

Thanks

Post #710306

« Prev Topic | Next Topic »

35 posts, Page 3 of 4

«««1 2 3 4 »»

Permissions