Is there any way i can rank student score in sql php?

Asked Sep 20 '21 at 17:58

Active Sep 20 '21 at 17:59

Viewed 15 times

table_result

regno      fullname     total     rankno
5780       sunday       90
5781       joy          100  
5782       emma         70
5783       samuel       80
5784       faith        80

expected result

regno     fullname    total     rankno
5781      joy         100        1
5780       sunday     90         2
5783       samuel     80         3
5784       faith      80         3

edited Sep 20 '21 at 17:59

MaartenDev

5,631
5
21
33

asked Sep 20 '21 at 17:58

iroba sunday

seems like `ORDER BY total DESC` would suit your needs? – MaartenDev Sep 20 '21 at 18:00
`Select * from your_table order by total desc;` – Ergest Basha Sep 20 '21 at 18:00
The answer to your question depends on your MySQL version. v8+, you can use the RANK() stuff (Windowing functions). Pre v8, you need to use @session variables. The linked question has answers showing both approaches. – O. Jones Sep 20 '21 at 18:05

Is there any way i can rank student score in sql php?

0 Answers0