What will be the order of null values in below query?

Create table test(a int)

insert into test values (null)
insert into test values (2)
insert into test values (3)
insert into test values (1)
insert into test values (null)

select *from test
order by a

 Posted by vishalneeraj-24503 on 11/26/2013 | Category: Sql Server Interview questions | Views: 5245 | Points: 40
Select from following answers:
  1. In the begining of the result set.
  2. In the last of the result set.
  3. Result set will not sow null values.
  4. In the order,the record has inserted into test table.
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response