Using MS SQL COUNT

One of the most used functions when writing queries in MS Sql is COUNT(). COUNT() , an "aggregate function", returns the number of records in the query.

Let's have a table named PRODUCTS as follows..

Product Price
Chocolate 5
Water 5
Pasta 3
Pen 10
Chocolate 7
Tea 20

The following query is written to fetch the number of records in this table.

SELECT COUNT(*) FROM PRODUCTS

The result will return us as 6.



You May Interest

What are the INTERSECT Operators in SQL Server ?

Changing Column Name of MS SQL Table with Query

What is the XML Datatype in SQL Server ?

What is Resource Governor in SQL Server ?

What is SQL Profiler ?