求一sql语句

表中的数据:

classID                     class                      name        

1                                  一班                        张三

2                                 一班                         李四

3                                 二班                         王五

4                                 二班                         赵六

5                                 二班                         刘七

查询后显示:

1                                  一班                        张三

2                                                                  李四

3                                 二班                         王五

4                                                                  赵六

5                                                                  刘七

©️2020 CSDN 皮肤主题: 大白 设计师:CSDN官方博客 返回首页