Mysql常用语句-2020.09.22

Mysql 常用语句

1.select * from students；

2.select * from students where score =90;

3. select * from students where score >= 60 and score <= 90;

4.select * from students where class_id <> 1;

5.select * from students where not class_id = 1;

6.select class_id,avg(score) from students group by class_id;

7.select * from students where order by score desc;