Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: DISTINCT and MAX
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