单项选择题
有雇员表employee(emID, emSex, emName),其中性别字段emSex使用0表示性别“女”,1表示“男”。如果查询结果的性别字段希望显示“男”、“女”,而不是1、0。正确的SELECT语句是______。
A、SELECT emID AS 员工编号, (WHEN emSex="0" THEN "女 ELSE "男’ END)AS 性别, emName AS姓名 FROM employee;
B、SELECT emID AS 员工编号, (IF emSex="0" THEN "女 ELSE "男’ END)AS 性别, emName AS姓名 FROM employee;
C、SELECT emID AS 员工编号, (CASE WHEN emSex="0" THEN "女 ELSE "男’ END)AS 性别, emName AS姓名 FROM employee;
D、SELECT emID AS 员工编号, (CASE emSex="0" THEN "女 ELSE "男’ END)AS 性别, emName AS姓名 FROM employee;