Subject 4 most recent detail rows per master row
Author gorepj
I have a master and detail table. The detail table contains a date
column. With a single SQL query I would like to return the four most
recent rows in the detail table for each master row. I've tried
various ways but most resulting in a 'multiple rows in a singleton
select error'

I'm using FB1.5

Peter Gore