Display Middle Record

BELOW example will give the middle row of the table(not sorted).

eg:

SELECT * FROM EMP WHERE ROWNUM <=(SELECT COUNT(1)/2 FROM EMP)
MINUS
SELECT * FROM EMP WHERE ROWNUM <(SELECT COUNT(1)/2 FROM EMP)

Below query will help you

SELECT * FROM EMP WHERE ROWNUM <=(SELECT COUNT(1)/2 FROM EMP)
MINUS
SELECT * FROM EMP WHERE ROWNUM <=(SELECT COUNT(1)/2 FROM EMP)

The following query works as follows: If the table has ten records, it will display the 5th and 6th record and if it has some 11 records, will display 6th record alone.

Code
SELECT * FROM table_name WHERE ROWNUM <= 
(SELECT CASE MOD(COUNT(1),2) 
WHEN 0 THEN(COUNT(1)/2) + 1 
ELSE ROUND(COUNT(1)/2) END FROM table_name)
MINUS
SELECT * FROM table_name 
WHERE ROWNUM < (SELECT (COUNT(1)/2) FROM table_name)

SELECT * FROM EMP WHERE ROWNUM <=(SELECT COUNT(1)/2 FROM EMP)
MINUS
SELECT * FROM EMP WHERE ROWNUM >=(SELECT COUNT(1)/2 FROM EMP)

The below code returns the rows from 50-74

Code
TO SELECT the middle rows:
        SELECT * FROM TABLE offset 50 rows fetch next 25 rows only
             

The below code selects the exact middle row from the table

Code
SELECT * FROM TABLE WHERE rownum=trunc(SELECT count(*)/2 FROM TABLE)