SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select *
into Products
from (values (cast(1 as money)), (5), (5), (3), (6)) v(unitprice)
5 rows affected

create function RankOfGivenPrice
    (@unitprice money)
    returns money
begin
return (
  select count(*) + 1 as RankNum
 from Products
 where UnitPrice > @unitprice)
 end;
select p.unitPrice, rank() over (order by unitprice desc), dbo.RankOfGivenPrice(p.unitPrice)
from products p


unitPrice
(No column name)
(No column name)


6.0000
1
1.0000

5.0000
2
2.0000

5.0000
2
2.0000

3.0000
4
4.0000

1.0000
5
5.0000

unitPrice	(No column name)	(No column name)
6.0000	1	1.0000
5.0000	2	2.0000
5.0000	2	2.0000
3.0000	4	4.0000
1.0000	5	5.0000