Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | 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;
link comment (0) accepted answer
asked 3 years ago
pevensie
54
8 Answers
1

COUNT(*) also counts NULL values.

link comment (0)
answered 3 years ago
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: