select 列名 --" * "表示所有列
from 表名
where 条件1
group by 分组
having 条件2 (与group by 一起使用)
order by 排序 (排序:ASC升序,DESC降序)
limit 结果限定
例如:
select min(borrowId),studentid, count(*) from borrowRecord group by studentId having count(studentId)>1
select * from student where id>5;