Re: only the first 10 rows

Select * from tablename
where rownum < 10;

Bear in mind that rownum doesn't always behave in certain complex queries.

Mark

Amir Zawar wrote in message <37578FF6.A3346D00_at_desy.de>...
>Hello all.
>I've a SQL problem.
>I have a table with abaut 20000 rows.
>But I want to get only the first 10 rows from this table (Top 10).
>How could I solved this problem ?
>(select * from tablename ....?)
>
>Amir
>
>
> Amir Zawar, Deutsches Elektronen-Synchrotron DESY
>...........................................................
> EMail: amir.zawar_at_desy.de
> Webserver: http://www.desy.de
>...........................................................
Received on Fri Jun 04 1999 - 04:25:45 CDT