Comments by RKMGROUP (Top 2 by date)

Hi,

Please use below example, it's helpful for you.

create table #temp
(
empid int
)

insert into #temp(empid) values(1)
insert into #temp(empid) values(2)
insert into #temp(empid) values(3)
insert into #temp(empid) values(5)


select * from #temp order by empid%2

-----------RAMESH-------------