help how get the n top rows for any table?
Hi, gurus!!! A need know how get n top row for any table somebody can help me!! Thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED] UNIX is very user friendly, It's just very particular about who it makes friends with. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: help how get the n top rows for any table?
If you're running Oracle8i, you can do this: SELECT * FROM (SELECT * FROM my_table ORDER BY col_name_1 DESC) WHERE ROWNUM 10; Use this workaround with prior releases: SELECT * FROM my_table a WHERE 10 = (SELECT COUNT(DISTINCT maxcol) FROM my_table b WHERE b.maxcol = a.maxcol) ORDER BY maxcol DESC ; Hope this helps! --- Alexander Ordonez [EMAIL PROTECTED] wrote: Hi, gurus!!! A need know how get n top row for any table somebody can help me!! Thanks!!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED] UNIX is very user friendly, It's just very particular about who it makes friends with. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: help how get the n top rows for any table?
Alexander, Tuesday, July 10, 2001, 1:45:51 PM, you wrote: AO Hi, gurus!!! AO A need know how get n top row for any table somebody can help me!! AO Thanks!!! AO @lex AO AO Lic. Alexander Ordóñez Arroyo AO Caja Costarricense del Seguro Social AO Soporte Técnico - División de Informática AO Telefono: 295-2004, San José, Costa Rica AO [EMAIL PROTECTED] AO AO UNIX is very user friendly, AO It's just very particular about who it makes friends with. Example with ROWNUM : SELECT COD FROM DETAIL WHERE ROWNUM 5 ORDER BY COD DESC This script gets 4 tops rows -- Breno A. K. Magnagomailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).