COUNT聚合函数,使用COUNT(*)或者COUNT(1)选出全部行,包含NULL列的统计。
COUNT(具体列),比如COUNT(id),则选出不包含id为NULL的汇总。
SET NULL UNKNOWN
DROP TABLE rl_test;
CREATE TABLE rl_test
(
id INTEGER,
name VARCHAR2(20)
);
begin
INSERT INTO rl_test VALUES(1,'Jack');
INSERT INTO rl_test VALUES(2,NULL);
COMMIT;
end;
SELECT COUNT(1) FROM rl_test;
SELECT COUNT(*) FROM rl_test;
SELECT COUNT(name) FROM rl_test;
Screen shot:
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24025515/viewspace-718998/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24025515/viewspace-718998/