Hi all,
I need to figure out the below Update query:
I have the below table:
Name Score COMMENT
Anna 10 Score 1
Anna 20 Score 2
Anna 30 Score 3
Anna 40 Score 4
Luis 4 Score 1
Luis 20 Score 2
Ivan 2 Score 1
I am wondering how to get the comments – the idea is that for the same name we compare the score and the lowest gets score 1, second lowest – score2, etc. If there is a single entry, it gets automatically score 1.
Do you have any suggestions?
Thanks in advance.