Select ROWID with a criteria
From: Marcelo Muzilli <marcelo_muzilli_at_hotmail.com>
Date: Tue, 29 Apr 2003 10:41:18 -0800
Message-ID: <oproel64efiqtw8z_at_news.ericsson.se>
Date: Tue, 29 Apr 2003 10:41:18 -0800
Message-ID: <oproel64efiqtw8z_at_news.ericsson.se>
Hi all,
how can I select a range of rows using rowid number?
For example, I would like to select this range of rows:
SELECT EMP_NAME FROM EMP WHERE ROWID(EMP) >= 10 AND ROWID(EMP) <=
1000;
I think that you can understand this clause.
Thanks in advance,
---
Marcelo Muzilli
Support Engineer
UIN: 1572797
marcelo_muzilli_at_hotmail.com
Received on Tue Apr 29 2003 - 20:41:18 CEST