数据库——模糊查询和聚合函数

使用like,between,in 进行模糊查询

模糊查询——LIKE

select name as 姓名 from Student where name like '张%'

ps:查询Student表中姓张的人的信息

like只与字符型数据联合使用

模糊查询——between

select name,score from Student where score between 60 and 80

等价于：select name,score from Student where score>=60 and score<=80

ps: between 80 and 60 

语句无误，但查询不到信息

模糊查询