Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: How to select specific rows in ANSI SQL ?

Re: How to select specific rows in ANSI SQL ?

From: Aakash Bordia <a_bordia_at_hotmail.com>
Date: Wed, 27 Dec 2000 17:10:58 -0800
Message-ID: <3A4A9322.5D0A3035@hotmail.com>

dont know if this is ANSI SQL but in DB2 you write: select * from where.....fetch first n rows only -Aakash

bdimple_at_my-deja.com wrote:

> Is it possible to code the equivalent of MySQL Specific LIMIT
> using ANSI SQL?
>
> For example, select * from where... LIMIT n1, n2?
> gives you the records starting from the n1-th result row and n2 results?
>
> I have tried joining the table to itself but I can't get it to work.
>
> I'd be very grateful for any and all suggestions.
>
> TIA
>
> B.Dimple
>
> Sent via Deja.com
> http://www.deja.com/
Received on Wed Dec 27 2000 - 19:10:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US