哈啰测开一面
- 给定一个学生表,查出名字一样的学生数目
select name,count(*) from student group by name having count(*) > 1
- 删除名字为张三,李四的学生的信息
delete from student where name in ('张三','李四')
字节测试一面
- 数据库查询10-20行内容
select * from student limit 9,19 //注意数据库行数从0开始
- message表内查找135开头的电话
select * from message where phone like "135%"
美团
- MySQL姓李的女生总数
select count(*) from student where name like "李%" and sex=1