create table TEST(ATIME time, AVAL integer);

select r.RDB$RELATION_ID, (select min(AVAL) from TEST where extract(hour 
from ATIME) = r.RDB$RELATION_ID)
from RDB$RELATIONS r
where r.RDB$RELATION_ID < 24 



Ответить