| Subject | Re: [firebird-support] SELECT FIRST N BY GROUP |
|---|---|
| Author | Dimitry Sibiryakov |
| Post date | 2019-08-07T13:21:06Z |
07.08.2019 14:26, pgore@... [firebird-support] wrote:
--
WBR, SD.
> Is this possible in a single SELECT queryI would try WHERE ROW_NUMBER() OVER (PARTITION BY empid, ORDER BY effdate) <= 2.
--
WBR, SD.