A decision has to taken carefully before we implement a solution for the two possibilities -

1. When we have odd total number of rows
2. When we have even total number of rows

My SQL will work differently in each case.

In first case (odd number of total rows), this SQL query will return middle record with out any conflict. Eg., If we have 9 records, this will display 5th record from table.

In second case (even number of total rows), this SQL query will return middle two...

sk_kireeti

select * from
(select rownum sno, empno,ename from emp)
where
sno =1
or sno=(select count(*) from emp);

sk_kireeti