Row Number en SQL Server

SELECT
   ROW_NUMBER() OVER(ORDER BY id ASC) AS 'Num',
   campo1,
   CASE Activo
      WHEN 1 THEN 'Activo'
      WHEN 0 THEN 'Inactivo' 
   end 'Estado',
   Activo
FROM namTable