write a query to display middle record in emp table

Answer 1

Write a query to add row number and from outcome select middle row number record.

Answer 2

select * from
(select ROW_NUMBER() OVER(ORDER BY empno)  sno, empno,ename from emp)
where
sno in
(
select floor((count(*)+1)/2) eg from emp
union
select ceil((count(*)+1)/2) eg from emp
)

Try this..