sql count how many times a value appears and output whole row code example

Example 1: how to count number of rows in sql

SELECT COUNT(*)
FROM dbo.bigTransactionHistory;

Example 2: sql count how many times a value appears

* For Example
- You have a table called t1 & in that table you want to know how many times "ABC" name occured.
So your query will be.

select name, count(*) as total FROM t1 GROUP BY name