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 (*) + $
Thursday, June 23, 2011
SQL Puzzle based on Select Count (*) $ | T-SQL Puzzle
T-SQL Puzzle
Merek:
COMPUTER,
Computer Awareness,
Quiz,
SQL Server Quiz,
T-SQL Puzzle
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment