请教一个问题，我想用SQL做一个统计：

[thedogstar]

请教一个问题，我想用SQL做一个统计：
select count(distinct "worker"."age","worker"."job")
into :l_count
from "worker" ;
统计WORKER里面不重复（年龄、职位）的人共多少，可是上面
的SQL语法错误，
select count(distinct "worker"."age")
into :l_count
from "worker" ; 这句语法正确，两个迭加就不行，
特请教。

[tanghuan]

select count(*)
from (
select distinct "worker"."age","worker"."job"
from "worker" ) as aa ;

[thedogstar]

谢谢大家了。

[zy]

select count(distinct "worker"."age","worker"."job")
into :l_count ,:j_count
from "worker" ;

[huntout]

count(distinct expression) expression只能是一個表達式
將兩個字段組合起來就行了

select count(distinct convert(varchar, "worker"."age") + "worker"."job")
into :l_count
from "worker" ;
語法不一定正確,希望有幫助 :p