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

Home -> Community -> Usenet -> c.d.o.tools -> Re: DISTINCT and MAX

Re: DISTINCT and MAX

From: Mike Moore <hicamel_at_mail.home.com>
Date: Sat, 07 Apr 2001 02:36:32 GMT
Message-ID: <Q2vz6.8467$4L4.916050@news1.frmt1.sfba.home.com>

Not really sure what you want because you say you want to select orderdates and then what you do is select ordernumber.

maybe
select ordernumber max(orderdate) from ordertable group by ordernumber; will give you what you want.
Mike

Ole Christian <olecl_at_stud.idb.hist.no> wrote in message news:3ACD937C.94429310_at_stud.idb.hist.no...
> My problem is like so:
> I want to select multipel orderdates which have the same date as the
> MAX-date of the table.
> But I'm just getting one date, the max date.
> I'm using this command:
>
> select distinct orderenumber from ordertable where orderdate=(select
> max(orderdate) from ordertable)
>
> Ole C.
> PS. I need help quickly...
>
Received on Fri Apr 06 2001 - 21:36:32 CDT

Original text of this message

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