sql number rows code example

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

SELECT COUNT(*) FROM tablename

Example 2: sql row number

SELECT 
  ROW_NUMBER() OVER(PARTITION BY recovery_model_desc ORDER BY name ASC) 
    AS Row#,
  name, recovery_model_desc
FROM sys.databases WHERE database_id < 5;