Unary & Aliases

Question

Post reply

Unary & Aliases

Carlo Romagnano

SSC-Insane

Points: 22669
More actions
September 12, 2011 at 9:45 pm

#256995

Comments posted to this topic are about the item Unary & Aliases
September 13, 2011 at 2:13 am

This was removed by the editor as SPAM

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

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Pretty easy question, if you eliminate incorrect answers.

@b-2 is never used, so the first and the last answer were impossible.

I knew there wasn't any incorrect syntax with the aliases, so the second answer was also incorrect. So that leaves us only with the arrays of numbers.

However, as the B column always returns 1, it was pretty easy to deduce the correct answer.

Nonetheless, great question which incorporated various scenarios. Thanks.

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

Iulian -207023 SSCertifiable Points: 7639 More actions · Answer 2

Iulian -207023

SSCertifiable

Points: 7639

September 13, 2011 at 1:16 am

#1380430

Thank you for the question,

regards,

Iulian

khelloufsofiane 6183 SSC Eights! Points: 942 More actions · Answer 3

khelloufsofiane 6183

SSC Eights!

Points: 942

September 13, 2011 at 2:02 am

#1380445

Thanks for the question.

🙂

Håvard Mr or Mrs. 500 Points: 569 More actions · Answer 4

Thanks for the question.

I got it wrong, and learned something!

Andre Guerreiro SSCertifiable Points: 7319 More actions · Answer 5

Thank you for the question.

Had to think this one through because of the operators.

And the variable was just to mess with us? 😛

Best regards,

Andre Guerreiro Neto

Database Analyst
http://www.softplan.com.br
MCITPx1/MCTSx2/MCSE/MCSA

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 6

Nice question, But i got it wrong.

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

Thomas Abraham SSChampion Points: 10761 More actions · Answer 7

Nice question Carlo! My first thought was, "What am I supposed to learn from this question?" Then I dug in a little deeper. Got it right, but not as quickly as I might have. I still haven't learned to read the title for help.

I still have the "Look at the shiny object ..." reaction when I follow the link to the question.

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

Britt Cluff SSCertifiable Points: 5083 More actions · Answer 8

Good question. I admit I had to run it to get the correct answer. Just couldn't visaulize it in my head.

http://brittcluff.blogspot.com/

ronmoses@gmail.com SSCarpal Tunnel Points: 4480 More actions · Answer 9

I'm hoping by this afternoon I will have read the explanation enough times to understand it, because I sure as heck don't at this hour of the morning! 😉

ron

-----
a haiku...

NULL is not zero
NULL is not an empty string
NULL is the unknown

Ernie Schlangen SSCrazy Points: 2382 More actions · Answer 10

Thanks for an interesting question. I got the right answer but not by thinking it all the way through so I learned something new - always a good way to start the morning!