SQL to sort employee based on even odd employee number

 

Expected Output:

 

 

drop table t;

create table t(empid number,ename varchar2(100));

insert into t values(1,'JEEVAN');

insert into t values(2,'RAVI');

insert into t values(3,'KATHIR');

insert into t values(4,'ARUN');

insert into t values(5,'MANI');

insert into t values(6,'PRAVEEN');

insert into t values(7,'RAGHU');

insert into t values(8,'MATHI');

insert into t values(9,'EZHIL');

insert into t values(10,'JAYA');

commit;

select empid,ename from t

order by mod(empid,2),empid;

select * from (select empid,ename from t

where  mod(empid,2)=0 order by empid)

union all

select * from (select empid,ename from t

where  mod(empid,2)=1 order by empid);