CURRENT AFFAIRS 2012 (TRIVIA QUIZ)

Here you will find Current affair Trivia Quiz, GK 2012, Latest Bank PO Materiel and article on Other topic to improve your GK.

polio

LightBlog

Breaking

Thursday, June 23, 2011

SQL Puzzle based on Select Count (*) $ | T-SQL Puzzle

T-SQL Puzzle
I have made this quiz by reading an interesting article on SQLAuthority by "Pinal Dave"(Microsoft MVP) and second article on beyondrelational.com by "Madhivanan"(Microsoft MVP).
Both are great article you can first try this quiz , then you can read the original article here and here.

So let us start
What would be the output of following Sql query?

1.) select *




2.) select count(*)





3.) select count(*) - count(*)




4.) select count(*) * 5




5.) select count(5)




6.) select count(5) - count(3)




7.) select count('9') - 2




8.) select '$'




9.) select $




10.) select $ - $




11.) Select Count (*) + $

No comments:

Post a Comment