查询借阅图书本数超过2本的读者号、总本数。并按借阅本数值从大到小排序
借阅表是这样的:
编号 读者号 书号 借出日期 应还日期
4 001974 TP311.13/CM3 2005-1-27 2005-3-28
1 001973 TP311.132/ZG1 2005-1-27 2005-3-28
3 001975 TP311.132/ZG1 2005-1-27 2005-3-28
6 001974 TP311.132/ZG1 2005-1-28 2005-3-28
2 001973 TP316/ZW6 2005-1-27 2005-3-28
5 001975 TP316/ZW6 2005-1-27 2005-3-28
借阅表是这样的:
编号 读者号 书号 借出日期 应还日期
4 001974 TP311.13/CM3 2005-1-27 2005-3-28
1 001973 TP311.132/ZG1 2005-1-27 2005-3-28
3 001975 TP311.132/ZG1 2005-1-27 2005-3-28
6 001974 TP311.132/ZG1 2005-1-28 2005-3-28
2 001973 TP316/ZW6 2005-1-27 2005-3-28
5 001975 TP316/ZW6 2005-1-27 2005-3-28
from table
group by 读者号
having count(*)>2
order by 总本数
from table
group by 读者号
having count(*)>2
order by 总本数 desc
from table
group by 读者号
having count(*)>2
order by count(*) desc
from table
group by 读者号
having count(*)>2
order by count(*) desc;