Tomathos Creative Commons License 2007.06.12 0 0 2357

Nemtom mennyire elegáns :)

 

 

SELECT kod,datum FROM (
SELECT ROWNUM rn,a.kod,a.datum,m FROM (SELECT kod,datum FROM BOLT b ORDER BY kod,datum
)a,(
SELECT kod,MAX(rn) m FROM (SELECT ROWNUM rn,kod,datum FROM (SELECT kod,datum FROM BOLT
ORDER BY kod,datum)) GROUP BY kod
) c WHERE a.kod = c.kod
) WHERE rn > m-4

Előzmény: stopposbácsi (2356)