Ranking duplicate values ​​with a different number

Question

Suppose I have a table containing names and numbers.

If there are 2 rows with the same values, it will get the same rank.

How can I give them a different number despite the same meaning?

So, for example, instead of my ranks like this - 1,2,3,3,4 (where points 3 and 4 have the same rank), I want my rank to look like this: 1,2,3,4, 5

Edit -

Displaying the line number does not help me because, as I said, I want to rank the lines.

Example -

If I use the regular rank, this is what I get. I want for User1 with a value of 80 it will show the rank of 2 and 3, and not 2 and 2. The same for User2. Using a line number will obviously not give me this result ....

╔═══════╦═══════╦══════╗
║ Name  ║ Value ║ Rank ║
╠═══════╬═══════╬══════╣
║ User1 ║    90 ║    1 ║
║ User1 ║    80 ║    2 ║
║ User1 ║    80 ║    2 ║
║ User1 ║    70 ║    3 ║
║ User2 ║   100 ║    1 ║
║ User2 ║    90 ║    2 ║
║ User3 ║    90 ║    2 ║
║ User3 ║    80 ║    3 ║
╚═══════╩═══════╩══════╝

, ... !

Answer 1

, ROW_NUMBER() .

DECLARE @tbl TABLE(Name VARCHAR(10), Value INT)

INSERT @tbl
    SELECT 'User1' ,    90 UNION ALL
    SELECT 'User1' ,    80 UNION ALL
    SELECT 'User1' ,    80 UNION ALL
    SELECT 'User1' ,    70 UNION ALL
    SELECT 'User2' ,   100 UNION ALL
    SELECT 'User2' ,    90 UNION ALL
    SELECT 'User3' ,    90 UNION ALL
    SELECT 'User3' ,    80

SELECT  Name, Value
        ,ROW_NUMBER() OVER(PARTITION BY Name ORDER BY Name, Value) AS Rn
FROM @tbl

Name    Value   Rn
User1   70      1
User1   80      2
User1   80      3
User1   90      4
User2   90      1
User2   100     2
User3   80      1
User3   90      2

Answer 2

RMDBS:

• SQL Server: ROW_NUMBER(). ANSI.
• ROWNUM.
• : http://blog.sqlauthority.com/2014/03/08/mysql-generating-row-number-for-each-row-using-variable/

:

SELECT FIELD_1, FIELD_2, ROW_NUMBER() FROM TABLE_A

,