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

Home -> Community -> Usenet -> c.d.o.misc -> limit

limit

From: Francesc Guasch <frankie_at_etsetb.upc.es>
Date: Tue, 23 Jun 1998 20:47:44 +0200
Message-ID: <358FF850.16AAACA6@etsetb.upc.es>


Can I do a select with a limit statement so :

select * from users limit 10;

so it only returns the first 10 in the query ? if so ... is there an easy way to return the next 10 items ?

thanks
--

mailto:frankie@etsetb.upc.es	http://www.etsetb.upc.es/~frankie

 ^-^.-----,       
 o o _     )        		Linux, Windows 95, and Windows NT
  Y (_, (__(Ssss (also known as the Good, the Bad, and the Ugly) Received on Tue Jun 23 1998 - 13:47:44 CDT

Original text of this message

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