Over Partition by

[roedelfroe]

Hi,

I've written a statement, which works fine but it is rather slow.

Does anybody got a better idea?

select * from
(
select a.*, row_number() over(partition by row1, row2 order by row3 desc) as xxx
from TABLE a
where DATE <= to_date('01.01.2009', 'DD.MM.YYYY')
and DELETED is NULL
) x
where xxx=1
order by row1, row2;

Thanks in advance

roedelfroe

 

[roedelfroe]

Sorry, wrong forum! Please ignore, I've asked my question in the correct forum again.

roedelfroe