mysql练习笔记

去重语句:

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)