//表结构和数据截图如下:
题目如下:
1)查询成绩在60~80之间的记录。
SELECT * FROM SC
WHERE GRADE BETWEEN 60 AND 80
2)查询成绩为85、86或88分的记录。
SELECT * FROM SC
WHERE GRADE IN (85,86,88)
标签：...,查询,60,88,SQL,86,SELECT,85 From： https://blog.51cto.com/softo/6023009
//表结构和数据截图如下:
题目如下:
1)查询成绩在60~80之间的记录。
SELECT * FROM SC
WHERE GRADE BETWEEN 60 AND 80
2)查询成绩为85、86或88分的记录。
SELECT * FROM SC
WHERE GRADE IN (85,86,88)
标签：...,查询,60,88,SQL,86,SELECT,85 From： https://blog.51cto.com/softo/6023009