Difference between Row_number() , Rank() and Dense_rank in sql

Row_number(), Rank() and Dense_rank in SQL

          The above three's are totally difference things, and every one will be using different situations.

All Example result will show depend on the below table.

select AssetID from Emp_tb_Asset_Transactions

Row_number()

          This is used to put just row number for every rows like below.

select Row_number() over(order by AssetID) RowNumber,* from(
select AssetID from Emp_tb_Asset_Transactions
)x

Rank()

     This is used to put row number rank wise.

select Rank() over(order by AssetID) RankNumber,* from(
select AssetID from Emp_tb_Asset_Transactions
)x

Dense_rank()

     This is used to put row number dense rank wise.

select Dense_Rank() over(order by AssetID) DenseRankNumber,* from(
select AssetID from Emp_tb_Asset_Transactions
)x