Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';
CREATE TABLE table_name (id, value) AS
SELECT LEVEL, CHR(64+LEVEL)
FROM DUAL
CONNECT BY LEVEL <= 10
ORDER BY DBMS_RANDOM.VALUE();
10 rows affected

SELECT *
FROM   (
  SELECT t.*,
         COUNT(*) OVER () AS num_rows
  FROM   table_name t
)
ORDER BY id
FETCH FIRST 5 ROWS ONLY


ID
VALUE
NUM_ROWS


1
A
10

2
B
10

3
C
10

4
D
10

5
E
10