POE Paste with lovely alien head...

No paste!

from "Stompro" at
Find auditor copy entries that are over x number of versions old.

format options below
-- Use window fuction to number each row in descending order, then choose
-- only the rows that are over a certain number. 
select * from
id,audit_id, audit_time
, row_number() over (PARTITION BY id order by audit_id desc) as rowcount 
from auditor.asset_copy_history
order by id
) x
where x.rowcount > 25

perl stuff: (might be helpful for others but not perfect)

Valid HTML 4.01!

Pastebot is powered by POE.