已经创建了如下视图,那么要查询所有男生姓名的最简洁SQL语句是________。 CREATE VIEW V_StSexMale AS SELECT StCode As 姓名, StName As 姓名, ClsCode As 班号, Sex As 性别 FROM Student WHERE Sex='男'
A、Select StName, Sex From V_StSexMale Where Sex='男'
B、Select StName, Sex From V_StSexMale
C、Select 姓名, 性别 From V_StSexMale Where Sex='男'
D、Select 姓名, 性别 From V_StSexMale