Re: Missing feature in informix?

At 09:19 AM 5/1/96, you wrote: >The following is missing in informix? >In oracle the server stops processing after selecting n rows thru > select * from tablea where rownum < 10 >In sybase equivalent is - > set rowcount 9 > select * from tablea >In informix ???!!>Is there a FAQ comparing oracle, sybase, informix which also gives functions and features availables >in informix and not in oracle,sybase and vice versa. >Like informix and oracle support ROW level locking(very important for some apps) which is missing >in SYBASE etc. >This info if compiled and published on internet will be very useful for the database community >to make decision to buy a RDBMS suitable to their needs? >al > > There is something in ISQL that will do this. See page 3-14 in Informix Guide to SQL Tutorial 4.10. But here is there select example: ----------------------------------------------------------- select order_num, total_price from items a where 10 > (select count(*) from items b where b.total_price < a.total_price) order by total_price -----------------------------------------------------------This gives you the 10 highest priced items ordered Scott