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

How is Auditing Different From Change Data Capture in SQL Server?

Getting List of All Views in MS SQL Database

MS SQL Compiling a Stored Procedure With a Requery

How is Sqlcmd Different from Osql ?

What is Log Shipping in SQL Server ?