".... where rownum <= #" example:
"select * from employees where nownum<=10 order by salary desc;" will return the 10 highest paid employees. -matt On Fri, 18 Jun 2004 [EMAIL PROTECTED] wrote: > on a mysql box I can limit the number of query results returned by tacking > a "LIMIT #" on the end of my query. That doesn't seem to work with the > Oracle 10G box I have. Is there a simple work-around? > > MRB > > > > ____________________ > BYU Unix Users Group > http://uug.byu.edu/ > ___________________________________________________________________ > List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list > ____________________ BYU Unix Users Group http://uug.byu.edu/ ___________________________________________________________________ List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
