Counting Rows with the COUNT(*) Function in SQL Server

Q

How To Count Rows with the COUNT(*) Function in SQL Server?

✍: FYIcenter.com

A

If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following tutorial exercise shows you some good examples:

SELECT COUNT(*) FROM fyi_links
GO
7

SELECT COUNT(*) FROM fyi_links 
   WHERE url LIKE '%fyi%'
GO
3

So there are 7 rows in total in table "fyi_links", and 3 rows that have 'fyi' as part of their url names.

 

Using SELECT Statements and GROUP BY Clauses in SQL Server

⇒⇒SQL Server Database Tutorials

2016-10-26, 698👍, 0💬