How to use COUNT function in SQL Server ?

        Here I explain you how to use COUNT function in SQL. COUNT function is very useful to count the number of records from table.

For explanation I consider a table with following records :

If you want to count total number of records from table, then you can use following statement :

We produce folowing result :

If you want to count total number of records for model excell, then you can use following statement :

We produce folowing result :

 If you want to count total number of records for address, then you can use following statement :

We produce folowing result :