SELECT ROWNUM NO,X.* FROM
(SELECT EMPLOYEE_ID,FIRST_NAME FROM HR.EMPLOYEES)X
----------------------------------------------------
NO EMPLOYEE_ID FIRST_NAME
----------------------------------------------------
1 198 Donald
2 199 Douglas
3 200 Jennifer
4 201 Michael
5 202 Pat
6 203 Susan
7 204 Hermann
8 205 Shelley
9 206 William
10 100 Steven
11 101 Neena
12 102 Lex
13 103 Alexander
14 104 Bruce
15 105 David
16 106 Valli
17 107 Diana
18 108 Nancy
19 109 Daniel
20 110 John
21 -- --
22 -- --

Menampilkan data dgn nomor urut 10 dan 17
---------------------------------------------------------------
SELECT Y.* FROM(
SELECT ROWNUM NO,X.* FROM(SELECT
EMPLOYEE_ID,FIRST_NAME FROM HR.EMPLOYEES)X
)Y
WHERE NO in(10,17)

Output :
-----------------------------------------------------
NO EMPLOYEE_ID FIRST_NAME
-----------------------------------------------------
10 100 Steven
17 107 Diana
----------------------------------------------------