• 2022-06-07
    现有学生关系表S(sno,sname,ssex,sage),查找比所有"张三"年龄大的男生信息,下列选项中正确的SQL语句是________。
    A: select * fromSwhere ssex='男' and sage>;SOME(select sage from S where sname='张三);
    B: select * fromSwhere ssex='男' and sage>;ALL(select sage from S where sname='张三);
    C: select * fromSwhere ssex='男' and sage>;(select max(sage) from S where sname='张三);
    D: select * fromSwhere ssex='男' and sage>;(select min(sage) from S where sname='张三);
  • 举一反三