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 (*) + $

0 comments:

Post a Comment

IBPS books (FREE shipping Cash on Delivery)

Kontera Ads