查询
来源：互联网 发布：433m无线模块数据手册 编辑：程序博客网 时间：2024/06/11 08:08
#排序
SELECT *
FROM SUBJECT
ORDER BY classHour DESC
#子查询1 --等值查询
SELECT id ,stuName
FROM student
WHERE id=(
SELECT b.stuNo
FROM SUBJECT AS a INNER JOIN result AS b ON b.subNo=a.id
WHERE a.subjectName='Logic Java'AND b.result >=80)
#子查询2 ---in
SELECT id ,stuName
FROM student
WHERE id IN=(
SELECT b.stuNo
FROM SUBJECT AS a INNER JOIN result AS b ON b.subNo=a.id
WHERE a.subjectName='Logic Java'AND b.result >=60)
0 0
