去重语句:
select distinct column from table where xxxx;
select distinct column1 column2 from table where xxxx;//两个条件必须全部相同,才能完成
范围查询
SELECT * from score where degree >60 and degree<80
select * from score where degree between 60 and 80;
多个选项查询:
or 或 in 都行
select * from score where degree=85 or degree=86 or degree=88;
select * from score where degree in (85,86,88)