how to count number of rows in sql

SELECT count(*)
FROM information_schema.columns
WHERE table_name = 'Your_table_nale';

SELECT COUNT(*)
FROM dbo.bigTransactionHistory;

/* 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;