聚集函数和null值

最新推荐文章于 2022-10-31 13:52:37 发布

zzm_

最新推荐文章于 2022-10-31 13:52:37 发布

阅读量265

点赞数

文章标签： python

原文链接：https://my.oschina.net/u/138995/blog/305997

版权

2019独角兽企业重金招聘Python工程师标准>>>

如果聚集函数作用域空值列，遇到空值行将被忽略。

INSERT INTO SCORE1(SNO,CNO,DEGREE)VALUES (103,'3-245',86);
INSERT INTO SCORE1(SNO,CNO,DEGREE)VALUES (105,'3-245',75);
INSERT INTO SCORE1(SNO,CNO,DEGREE)VALUES (109,'3-245',68);
INSERT INTO SCORE1(SNO,CNO,DEGREE)VALUES (103,'3-105',92);
INSERT INTO SCORE1(SNO,CNO,DEGREE)VALUES (105,'3-105',88);
INSERT INTO SCORE1(SNO,CNO,DEGREE)VALUES (109,'3-105',76);
INSERT INTO SCORE1(SNO,CNO,DEGREE)VALUES (101,'3-105',64);
INSERT INTO SCORE1(SNO,CNO,DEGREE)VALUES (107,'3-105',91);
INSERT INTO SCORE1(SNO,CNO,DEGREE)VALUES (108,'3-105',78);
INSERT INTO SCORE1(SNO,CNO,DEGREE)VALUES (101,'6-166',85);
INSERT INTO SCORE1(SNO,CNO,DEGREE)VALUES (107,'6-106',79);
INSERT INTO SCORE1(SNO,CNO,DEGREE)VALUES (108,'6-166',81);
insert into score1 (SNO,CNO,DEGREE) values(109, '6-106', null);

select avg(degree) from score1;

80.25

select avg(degree) from score1 where degree is not null;

80.25

select count(degree) from score1

select count(*) from score1;

select max(degree), min(degree) from score1;

92 64

转载于:https://my.oschina.net/u/138995/blog/305997