Hi

Can we get any poinsts for such questions ?

Hi All

I tried the query with all the given option. All the option returns the NULL value.

Hi

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...

Hi

The Query need the GROUP BY clause also, as we are using SUM an aggregate function.

Hi Hugo Kornelis,

Thanks a lot.

Hi All

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...

Hi All

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.

3rd...

Hi

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 ?