PARTITION in sql|delete duplicate rows in sql using partition

Sql sever using PARTITION
 select  ROW_NUMBER() OVER(PARTITION BY  transactionHeadName 
 order by transactionHeadName ) AS Row1,
 TransactionHeadName from TransactionHeadbalance order by code
Result

Post a Comment

0 Comments