Re: Query help - partition effective dates and collapse rows
From: Stefan Moeding <dba_at_moeding.net>
Date: Thu, 04 Feb 2010 19:06:29 +0100
Message-ID: <87vdecri2v.fsf_at_esprit.moeding.net>
Hi,
WHERE rnum = 1
Date: Thu, 04 Feb 2010 19:06:29 +0100
Message-ID: <87vdecri2v.fsf_at_esprit.moeding.net>
Hi,
I believe the following should do what you are looking for:
SELECT ...
FROM (SELECT boat_id, service_type, effective_date,
row_number() over (partition by boat_id, service_type
order by effective_date) as rnum
FROM ...)
WHERE rnum = 1
Regards,
Stefan
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Feb 04 2010 - 12:06:29 CST