Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> strange behaviour (query) ...

strange behaviour (query) ...

From: Michael Agbaglo <byteshif_at_cs.tu-berlin.de>
Date: 1997/02/24
Message-ID: <01bc229f$8ece9920$0200000a@pitfall>#1/1

SQL*Plus: Release 3.2.2.0.1 - Production on Mon Feb 24 21:34:09 1997

I want to determine the 2nd greatest number. Why does

SELECT MAX(a)
FROM banane MINUS ( SELECT MAX(a) AS x FROM banane );

not work ? Why are 3 SELECTs necessary ?

(Personal Oracle7 Release 7.2.2.3.1)

SQL> SELECT * FROM banane;

        A


        1
        2
        3
        5

SQL> SELECT MAX(a)
  2 FROM banane MINUS ( SELECT MAX(a) AS x FROM banane );

no rows selected

SQL> SELECT MAX(a)
  2 FROM ( SELECT * FROM banane MINUS ( SELECT MAX(a) FROM banane));

   MAX(A)


        3 Received on Mon Feb 24 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US