At 05:01 PM 8/12/2004 +0000, you wrote:

>Hi All,
>How to write this sql in firebird:
>
>select depart
>from employee
>where age >= all (select age from employee)
>
>i.e how to use 'all' in Firebird, suppose 'age' is a subquery

Because your query is re-entrant, you'll need to use aliases:

select e.depart
from employee e
where e.age >= all (select e1.age from employee e1)

./hb