SCENARIO
Suppose you have a table, now you want to know the number of records in it. Then COUNT function will do the job.
SYNTAX of COUNT()
SELECT COUNT(ColumnName) from Table_NAME;
Suppose we have a table named Table_NAME
as
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;
Suppose you have a table, now you want to know the number of records in it. Then COUNT function will do the job.
SYNTAX of COUNT()
SELECT COUNT(ColumnName) from Table_NAME;
Suppose we have a table named Table_NAME
as
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