You want "first 10"

In article <ccrgmi+qaqb@...>, Monaasn wrote:

> I have query sort order by value. I want just top 10 record. At MS
> SQL Server I can use :
>
> Where rownum <=10
>

--
Nick
-----We Solve your Computer Problems---
Founder & Listowner of the Prolifics User Group
Panther, Ingres, UNIX, Interbase, Firebird - Available Shortly