Re: OFFSET function in oracle
From: Christine <karistom_at_hotmail.com>
Date: 20 Nov 2003 23:53:13 -0800
Message-ID: <693b7163.0311202353.7ed24e4d_at_posting.google.com>
Date: 20 Nov 2003 23:53:13 -0800
Message-ID: <693b7163.0311202353.7ed24e4d_at_posting.google.com>
this may help you ....
select * from mytable where rownum <= 20
minus
select * from mytable where rownum <= 10
"¢Ð¢ý¢ö" <_at_.@> wrote in message news:<bpc5i8$khq10_at_imsp212.netvigator.com>...
> I want to retrieve a range of record
> such as retrieving 11th to 20th records from 10000 records
> In SQL Server, i can use the "OFFSET" function.
> so i wanna ask does Oracle provide any function similar to "OFFSET" in SQL
> SERVER?
>
>
>
> Thanks in advance
> Regards
> Bun
Received on Fri Nov 21 2003 - 08:53:13 CET