摘要:
use stu select cno,cname from course where not exists( select * from sc where sno = '201215121' and cno=course.cno ) select sname from student where s 阅读全文
摘要:
Select 结构: 句子结构: Select 列名 [all/distinct] from 表名 where 条件 group by 按该列数值分组 having 聚合条件 order by 升序/降序 执行优先级 5 1 2 3 4 6 关键字说明: 子句 执行顺序 必填/选填 说明 SELEC 阅读全文
摘要:
where select sname,sdept,sage from student where ssex = '男' or ssex = '女' and sage not between 20 and 23 select distinct sno from sc where cno between 阅读全文