日期:2014-05-17 浏览次数:21161 次
SELECT COUNT(CASE
WHEN fsalary > 9999 and fage > 35 THEN
1
ELSE
NULL
END) A,
COUNT(CASE
WHEN fsalary > 9999 and fage < 35 THEN
1
ELSE
NULL
END) A,
COUNT(CASE
WHEN fsalary < 9999 and fage > 35 THEN
1
ELSE
NULL
END) A,
COUNT(CASE
WHEN fsalary < 9999 and fage < 35 THEN
1
ELSE
NULL
END) A
FROM empinfo
SELECT CASE
WHEN fsalary > 9999 and fage > 35 THEN 'fsalary > 9999 and fage > 35'
WHEN fsalary > 9999 and fage < 35 THEN 'fsalary > 9999 and fage < 35'
WHEN fsalary < 9999 and fage &