Rank with Total

[Ra Nala]

Hi Sir,

I am using InnoDb, 5.7.11 version

I am not able to provide more info on @curRank but my intention is i am able to generate rank and i want to set final rank (i.e. 3) to my other column(emp_count).

Could you please help me how can i set final rank to emp_count column. Kindly help me.



Emp_id Emp_Sal Emp_rank Emp_count
------- ------- ------- -------
1 100 1 3
2 200 2 3
3 300 3 3


Thanks for your support