Re: How to limit # of rows returned by SELECT

Hi Gordon,

try select * from <your_table> where rownum < 11;

for the first ten items.
Note that the rownum is calculated last, so any other where clauses with rownum will probably not work.

HTH, Toni

-- 
A. Dischner, AIX sysadmin, Oracle DBA           | Two planets meet;
Institut fuer Klinische Chemie                  | How are you ?
Klinikum Grosshadern                            | Bad ... , i 've got 
Ludwig Maximilians Universitaet Muenchen,  GER  | homo sapiens :-)
Marchioninistr.15 81366 Muenchen 49-89-70953202