Thursday, 28 May 2015

SQL Query COUNT() function syntax

Suppose you have a table, now you want to know the number of records in it. Then COUNT function will do the job.


SELECT COUNT(ColumnName) from Table_NAME;

Suppose we have a table named Table_NAME
sql result image

Now if we run query     SELECT COUNT(ColumnName1) from Table_NAME;

Output = 4
 or if we run  SELECT COUNT(ColumnName3) from Table_NAME;

Output= 2
it means if we are running count on columns then it neglects the null value columns.

If you want to know the total number of records in a table then you can simply use
SELECT COUNT(*) from Table_NAME;

No comments:

Post a Comment