MySQL Rank Function?

Question

How to use rank function in MySQL? Below is my requirement.

I need the rank based on FirstName, LastName,MemberID & DOB. If a record matches all the listed four columns then I need to assign rank as above. In oracle I have rank function to obtain the same. How to achieve the same in MySQL?

I'm sorry. I don't know how insert a table in the textbox. Please help. — chaitanya, Apr 23 '17 at 01:32

score -1 · Answer 1 · answered Apr 23 '17 at 01:38

-1

You can do this with variables in SQL Server:

select t.*,
       (@rn := if(@v = concat_ws(':', FirstName, LastName, MemberID, DOB), @rn + 1,
                  if(@v := concat_ws(':', FirstName, LastName, MemberID, DOB), 1, 1)
                 )
       ) as rank  
from t cross join
     (select @rn := 0, @v := '') params
order by FirstName, LastName, MemberID, DOB, lastLoginTime

answered Apr 23 '17 at 01:38

Gordon Linoff

1,242,037
58
646
786

And why does this have a downvote? I'm pretty sure this is correct. – Gordon Linoff Apr 23 '17 at 03:04

MySQL Rank Function?

1 Answers1