Hi,

I know its very simple. But I have very archive knowledge in oracle (last time I used is in 1999).

I would like to know - how to retrive top 10 records from a table.

In SQL Server its like this - select top 10 * from table_name

Any help, appreciated.

Thanks in advance

I got the answer.

I was bit lazy before my lunch.

Thanks any how,

Of course you know the answer. Its like -
select * from ut_lookup_types where rownum<11;

You may be able to use ROWNUM, depending on your query.

select * from table_name where rownum < 11

Check the oracle docs and this thread.