Oracle 18c

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

CREATE TABLE MYTABLE (SEQ_NBR NUMBER);
INSERT INTO MYTABLE
SELECT LEVEL FROM DUAL CONNECT BY LEVEL <= 2000;
2000 rows affected

SELECT
    SEQ_NBR,
    COUNT(*) OVER() TOTAL
FROM
    (
        SELECT
            M.SEQ_NBR
        FROM
            MYTABLE M
        ORDER BY
            SEQ_NBR DESC
        FETCH FIRST 10 ROWS ONLY
    );


SEQ_NBR
TOTAL


2000
10

1999
10

1998
10

1997
10

1996
10

1995
10

1994
10

1993
10

1992
10

1991
10

SEQ_NBR	TOTAL
2000	10
1999	10
1998	10
1997	10
1996	10
1995	10
1994	10
1993	10
1992	10
1991	10