Re: Basic SQL question I think

From: me <m1ke0_at_yahoo.com>
Date: Thu, 18 Jan 2001 06:40:59 -0800 (PST)
Message-Id: <10745.126990@fatcity.com>

here's the standard top three query from some book, i don't remember which one though:

SELECT (SAL * (-1))
              ,EMPNO
FROM
 ( SELECT (SAL * (-1)) SAL

                   ,EMPNO

    FROM EMP
   GROUP BY (SAL * (-1))

                   ,EMPNO)

WHERE ROWNUM < 4;

• nlzanen1_at_ey.nl wrote:
  > Hi All,
  >
  >
  > I guess I'm braindead already (not even friday yet)
  >
  > I have a table with two columns
  > column A number
  > column B varchar2
  >
  > I need to have the top ten numbers from this table (column a)
  > The numbers are in random order.
  > I have tried all sorts of stuff with ordering etc but to no avail.
  >
  > Anybody feeling lucky??
  >
  >
  > TIA
  > Met vriendelijke groet,
  >
  > Jacob van Zanen
  > (Oracle DBA) Informatie Systemen
  >
  > Ernst & Young
  > Informatie & Communicatie Technologie
  >
  > Kantoor Gouda
  > Tel.: 0182 575316 (intern: 923 316)
  > Fax: 0182 536311
  > E-mail: nlzanen1_at_ey.nl
  >
  

  ---

Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. Received on Thu Jan 18 2001 - 08:40:59 CST