What is the meaning of count(10) in SQL?

Question

What it does exactly. What this will return?

Note that an example SQL query would help us understand exactly what you are asking. Do you mean `select count(10) from MyTable`? — Paul Williams, Dec 13 '17 at 21:05

score 0 · Answer 1 · edited Dec 14 '17 at 03:20

0

This function returns the number of rows that matches a specified criteria. For example if you search the products table and the query returned 10 rows, the function count(*) returns the value of 10.

edited Dec 14 '17 at 03:20

Tom Aranda

5,919
11
35
51

answered Dec 13 '17 at 20:57

Hugo Valenza M

169
1
6

Can you plz add example? – Gokul Dec 13 '17 at 20:58

score 0 · Answer 2 · answered Dec 13 '17 at 21:04

0

You can write any number, count(0) - count(999999) that means count(*)

answered Dec 13 '17 at 21:04

Javlon Ismatov

194
12

score -1 · Answer 3 · answered Dec 13 '17 at 21:04

-1

For example if you use this query:

select count(*) from users;

and this query return 10 rows, the count() function also return you this value.

you can put the name of column in count function and the count work only with the results with this column.

answered Dec 13 '17 at 21:04

Hugo Valenza M

169
1
6

What is the meaning of count(10) in SQL?

3 Answers3