Difference When Using ROWNUM

Question

I am looking for an Oracle swap request on the network, and most of them told me to execute the request twice:

SELECT * 
  FROM (SELECT t.*, ROWNUM rn 
          FROM tableName t 
         WHERE ROWNUM < 200) 
 WHERE rn > 100

Just wondering if I can type it like:

SELECT *, ROWNUM rn 
  FROM tableName t 
 WHERE ROWNUN BETWEEN 100 AND 200

It seems the second one works. Are there any (working) differences between the two queries?

+5

Garyx Aug 16 '11 at 3:47

2 answers

ROWNUM:

SELECT x.* 
  FROM (SELECT t.*, 
               ROWNUM rn 
          FROM tableName t) AS x
 WHERE x.rn > 100
   AND x.rn < 200

BETWEEN , .

ROWNUM . ( Oracle.

+4

OMG Ponies 16 . '11 3:52

AaronLS · Accepted Answer · 2011-08-16T03:59:05+0000

, , ROWNUM. , , , rownum, . BETWEEN , , , , , . , , .

SELECT * FROM employees
    WHERE ROWNUM > 1;

" ROWNUM 1 . , , , ROWNUM 1 . , ."