Create Serial Number Column using postgresql

Create Serial Number Column

Qurey:

SELECT ROW_NUMBER()  OVER (ORDER BY  ColumnName1) As SrNo, ColumnName1,  ColumnName2 FROM  TableName

Example:

select row_number() over (order by user_nm) as slno, user_nm from user_pass