mike (4/22/2009)

---

Hey! Not fair. I lost a point because of a missing ORDER BY ? Like a previous poster mentioned, both 1 and 2 are correct.

Can I get my point back please?

Jayeff (4/22/2009)

---

Yeah, me too!

SanjayAttray (4/22/2009)

---

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.

NULL 1
NULL manoj

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.

r.hensbergen (4/22/2009)

---

And see, you both got you point just by posting that you want your point back. ;)

SanjayAttray (4/22/2009)

---

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.

NULL 1
NULL manoj

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.

select NULL,'manoj'
union select Null,'1'
union select NULL,'manoj'
order by 2 desc

            
----------- -----
NULL        manoj
NULL        1

(2 row(s) affected)