{ 29 03 2006 03:03 }

Limit number of rows in an oracle query

select *
from (
select *
from (select * from CODETABLE_READCODE)
order by DESCRIPTION
)
where rownum <= 6

Share

Posted by Jim Barritt on Wednesday, March 29th, 2006, at 15:13, and filed under databases, oracle, sql.

Follow any responses to this entry with the RSS 2.0 feed.