Sort Order - Include Null al last

Question

Post reply

Sort Order - Include Null al last

Viewing 4 posts - 136 through 138 (of 138 total)

You must be logged in to reply to this topic. Login to reply

majorbloodnock SSCrazy Eights Points: 9389 More actions · Answer 1

Anirban Paul (6/25/2008)
Cheers to Steve.........:)
I believe u are not going to deduct points for posting here 😉

Now that's an idea...... 😎

Semper in excretia, suus solum profundum variat

akila.purushothaman SSC-Addicted Points: 404 More actions · Answer 2

The given answer here is wrong which is not displaying the dateofleaving in ascending order.

I think the correct answer is,

select * from employees

order by dateofleaving desc,empname asc

kevlray SSCommitted Points: 1908 More actions · Answer 3

Just because I a bit of a newbie with SQL in general. I created the table and poplulated. Verified I had the right value and in SQL Server 2005 the statment 'SELECT EmpName, DateOfLeaving from #Employees ORDER BY DateOfLeaving DESC, EmpName ASC' got the correct answer.

I did not try the supposed solution.

Thanks.

Balachandra SSCrazy Points: 2606 More actions · Answer 4

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 option is the correct , not the 2nd option.

Balachandra Srinevasalu