how to count number of rows in sql
snippet in sql

how to count number of rows in sql

user4431

SELECT COUNT(*)
FROM dbo.bigTransactionHistory;

sql count

user2927

/* COUNT() is a function that takes on the name of a clomn as an argument
and counts the number of rows where the column is not null */

SELECT COUNT(column_name)
FROM table_name;