Re: chosing id of max values

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Tue, 24 Jul 2007 16:49:24 +0200
Message-ID: <46A61174.6040008@gmail.com>

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_Time 
DESC) 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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 24 2007 - 09:49:24 CDT