| Subject | 4 most recent detail rows per master row |
|---|---|
| Author | gorepj |
| Post date | 2007-09-21T14:38:38Z |
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
Regards
Peter Gore
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
Regards
Peter Gore