Re: [WDSCI-L] SQL getting record with last date/Time

[Jerome Hughes <jromeh@xxxxxxx>]

   From:     jromeh@xxxxxxx
   Subject:    Re: [WDSCI-L] SQL getting record with last date/Time
   Date:   August 31, 2006 2:44:24 PM CDT
   To:       wdsci-l@xxxxxxxxxxxx

Michael--

here's one way...

select a.logdate, max(a.logtime)
from logfile a
group by a.logdate
where a.logdate = (select max(b.logdate) from logfile b)

thx & hth,

--Jerome


On Aug 31, 2006, at 2:34 PM, Smith, Mike wrote:


>  L      ADMIN_BW    HARLESSD    20060830   155855
>  U      ADMIN_BW    CHISOMT     20060831   143021
>  L      ADMIN_BW    CHISOMT     20060831   143250
>
> I need to do an sql select statement that will retrieve the highest  
> date
> in a file, but also the highest time for that particular date.
>
> Originally I was just getting the latest date with  a Select
> max(logDate).
>
> I then tried knowing it wouldn't work  Select max(logdate),
> max(logTime).
>
> In the above records I would want  20060831- 143250
> How would I accomplish this?
>
>
> Michael Smith
> iSeries.mySeries.
>
> --
> This is the Websphere Development Studio Client for iSeries  (WDSCI- 
> L) mailing list
> To post a message email: WDSCI-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/wdsci-l
> or email: WDSCI-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/wdsci-l.