The " COUNT(column_name)" would return the number of records in that particular field but if we use "COUNT(*)" function, from which field are the number of records counted? Thanks in advance!

Hi Meenakshi! Thanks for reaching out. The COUNT(*) returns the number of rows in a dataset using the SELECT statement. The function counts rows with NULL, duplicate, and non-NULL values. While, COUNT(column_name) counts the records only for this particular column, COUNT(*) counts all rows regardless the columns. All columns have the same length. Hope this helps. Best, Tsvetelin

Follow this topic

Meenakshi Akila P.S

Last answered:

16 Dec 2021

Posted on:

05 Nov 2021

Regarding COUNT(*) function

in SQL / COUNT()

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

16 Dec 2021

Regarding COUNT(*) function

Submit an answer

related questions