姓进行统计并从大到小排名 --应该用order byselect * from 班级名册表 order by 班级的姓 desc --拼音音序select * from 班级名册表 order by 班级的姓 collate Chinese_PRC_Stroke desc --笔画大小
select left(姓名,2)姓,count(*) from 班级名册表 group by left(姓名,2) order by left(姓名,2) desc
--测试表: create table class ( student_name varchar(255) ) go--测试数据: insert into class values ('张三') go insert into class values ('李四') go insert into class values ('王五') go insert into class values ('赵大') go--SQL Code: select * from class group by student_name order by left(student_name,2) desc--Result: student_name 1 赵大 2 张三 3 王五 4 李四
--应该用order byselect * from 班级名册表 order by 班级的姓 desc --拼音音序select * from 班级名册表 order by 班级的姓 collate Chinese_PRC_Stroke desc --笔画大小
from 班级名册表
group by left(姓名,2)
order by left(姓名,2) desc
--测试表:
create table class
(
student_name varchar(255)
)
go--测试数据:
insert into class values ('张三')
go
insert into class values ('李四')
go
insert into class values ('王五')
go
insert into class values ('赵大')
go--SQL Code:
select * from class
group by student_name
order by left(student_name,2) desc--Result: student_name
1 赵大
2 张三
3 王五
4 李四