From RICHARD.T.CALE@saic.com Mon, 10 Sep 2001 07:51:13 -0700 From: "Cale, Rick T (Richard)" Date: Mon, 10 Sep 2001 07:51:13 -0700 Subject: RE: query for top customer Message-ID: MIME-Version: 1.0 Content-Type: text/plain SELECT customer,sales FROM (SELECT customer,sales FROM table_a ORDER BY sales DESC) WHERE rownum < 4; Must be running at least 8i for this to work Rick -----Original Message----- Sent: Monday, September 10, 2001 9:30 AM To: Multiple recipients of list ORACLE-L how to write a query to find top 3 customer based on their sales . eg. TABLE A customer sales A100 100 A101 200 A102 105 A103 109 A104 108 RESULTS should be.. A101 200 A103 109 A104 108 Thanks in advance Brajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oracle DBA INET: oradba@tubes.tatasteel.com 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: ListGuru@fatcity.com (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: RICHARD.T.CALE@saic.com 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: ListGuru@fatcity.com (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).