sql select number of rows code example

Example 1: sql query to get the number of rows in a table

SELECT COUNT(*) FROM tablename

Example 2: how to count number of rows in sql

SELECT COUNT(*)
FROM dbo.bigTransactionHistory;

Example 3: rownum in sql

SELECT ROWNUM, a.*
FROM (SELECT customers.*
      FROM customers
      WHERE customer_id > 4500
      ORDER BY last_name) a;

Tags:

Sql Example

Related