select NULL,'manoj'union select Null,'1'union select NULL,'manoj'

order by 2

or

select NULL,'manoj'union select Null,'1'union select NULL,'manoj'

order by 1

gives you same result.

NULL1

NULLmanoj

I tried on all sql server versions and result is same. May be I am missing something here when some people are telling both 1 & 2 answers are correct.