sql | 基础总结 | 思维导图

Select * from 表名 Select * from stuInfo

Select 字段1,字段2,字段3… from 表名 Select stuName,stuSex from stuInfo

select distinct 列名1 from 表名

Select * from score where degree between 60 and 80

select * from score where degree in (85,86,88)

select * from score where degree>=60 and degree<=80

select * from student where class='95031‘ or Ssex='女'

select * from student order by class desc

select count(*) as CNT from student where class='95031'

select max(degree) From Score

select min(degree) From score

select avg(degree) as 课程平均分 from score where cno='3-105';

select cno, avg(degree) from score where cno like'3%‘ group by cno having count(*) >5