Generate Row Unique Numbers in SQL Query|ROW_NUMBER() in sql|Row number in sql

ROW_NUMBER() in sql

select  ROW_NUMBER() OVER(order by Code ) AS Row1,
TransactionHeadName from TransactionHeadbalance order by code

Result