sql之分组
分组
-
按照哪一类进行分组,关键词group by;
-
通俗一点,就是把某一些满足设定条件的数据按某种规则进行合并
-
创建表
create table student (id int not null, name1 varchar(30), grade varchar(30), salary varchar(30)) insert into student values(1,'zhangsan','A',1500); insert into student values(2,'lisi','B',3000); insert into student values(1,'zhangsan','A',1500); insert into student values(
-