select first 3 * from табличка 
where id=1
order by date desc
union all
select first 3 * from табличка 
where id=2
order by date desc
union all
select first 3 * from табличка 
where id=3
order by date desc

recreate table td(id int, dt date);
commit;
insert into td select rand()*5, dateadd( rand()*100 day to date '01.01.2014')
from rdb$types, rdb$types;
commit;
create index td_id on td(id);
create descending index td_dt_desc on td(dt);
commit;

with
c as(
    select id, max(dt) d1 from td group by id
)
,d as(
    select id, d1, (select dt from td x where x.id=c.id and x.dt < c.d1 order by x.dt desc rows 1) d2
    from c
)
,e as(
    select id, d1, d2, (select dt from td x where x.id=d.id and x.dt < d.d2 order by x.dt desc rows 1) d3
    from d
)
select
    id
    ,decode(n.i, 1, d1, 2, d2, d3) dx
from e,(select 1 i from rdb$database union all select 2 from rdb$database union all select 3 from rdb$database) n

SELECT  id,
        sum(id) OVER()
    FROM
        t

SQL error code = -104.
Token unknown - line 2, column 24.
(.