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 (*) + $
الخميس، 23 يونيو 2011
SQL Puzzle based on Select Count (*) $ | T-SQL Puzzle
الاشتراك في:
تعليقات الرسالة (Atom)
ليست هناك تعليقات:
إرسال تعليق