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_at_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 Thu Dec 28 2000 - 02:10:58 CET

Original text of this message