Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register


3
(click on this box to dismiss)

What is the difference between COUNT(*) and COUNT(column)

What is the difference between

SELECT count(*) FROM table;

and

SELECT count(i) FROM table;
링크 댓글 쓰기 (0) 선택된 답변
질문시간 3년 전
pevensie
54
8 답변들
1

COUNT(*) also counts NULL values.

링크 댓글 쓰기 (0)
답변시간 3년 전
ginarrbrik
516
tagged




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: