how to count element on sql code example

Example 1: how to count number of rows in sql

SELECT COUNT(*)
FROM dbo.bigTransactionHistory;

Example 2: counting in sql

SELECT COUNT(*) FROM EMPLOYEES;