Viewing 8 posts - 1 through 8 (of 8 total)
Can we get any poinsts for such questions ?
April 12, 2009 at 11:50 pm
I tried the query with all the given option. All the option returns the NULL value.
April 5, 2009 at 11:54 pm
The given script will work in SQL Server 2000 giving the results 1,2,3,4,5,6.
In SQL Server 2008 it fails saying conversion failed when converting the varchar value 'A' to data...
March 26, 2009 at 1:24 am
The Query need the GROUP BY clause also, as we are using SUM an aggregate function.
March 18, 2009 at 9:16 am
Hi Hugo Kornelis,
Thanks a lot.
March 16, 2009 at 2:51 am
I am not sure wichi is correct answer. Beacuse the same question is repeted twice.
1st time i entered as 0 and answer was wrong.
2nd time i entered as 1...
March 16, 2009 at 1:45 am
I have tested the query by creating the table.
Select EmpName, DateOfLeaving from Employees order by DateOfLeaving desc, EmpName asc
Only the above statement will return the required output.
March 16, 2009 at 1:31 am
In the MSDN blog says both the code is same. But the answer returned in wrong.
could you please help us which one is correct ?
March 12, 2009 at 2:55 am