question (or feature-request): over ( partition by ... order by LIMIT N)

Hello @all,

I know, i can do:

select * from (select ... row_number() over (...) ...) foo where row_number < N

to limit the rows per group, but the inner select has to retrieve the
whole set of records and in the outer select most of them discarded.


Why isn't there an over ( ... LIMIT N) ?

Other (better) solution?



Regards, Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431  2EB0 389D 1DC2 3172 0C99