Re: chosing id of max values - oracle-l - FreeLists

Re: chosing id of max values

From: Maxim Demenko <mdemenko@xxxxxxxxx>
To: rems@xxxxxxxx
Date: Tue, 24 Jul 2007 16:49:24 +0200

Maybe, something like this ?
SELECT MAX(l.Id) Keep(Dense_Rank() FIRST ORDER BY Start_Time DESC) Over(),
      MAX(l.Wid) Keep(Dense_Rank() FIRST ORDER BY Start_Time DESC) Over(),

MAX(l.Start_Time) Keep(Dense_Rank() FIRST ORDER BY Start_TimeDESC) Over(),

      MAX(b.Wid) Keep(Dense_Rank() FIRST ORDER BY Start_Time DESC) Over()
FROM   Wptv_Listings l
JOIN   Wptv_Blocks b ON l.Id = b.Id
WHERE  l.Visible = 'T'
AND    l.Start_Time BETWEEN < Date1 > AND < Date2 >


Best regards

Maxim
--
//www.freelists.org/webpage/oracle-l

References:
- chosing id of max values
  - From: Remigiusz Sokolowski

Other related posts: