Hi,
Using FirebirdCS-1.5.0.4027-RC7.i686.rpm:

Suppose I have a table with 30 million records as follows:

create table (
name char(10),
age integer
);

Can anybody suggest an efficient method of calculating the median age
(not average) ?

thanks
bill