Find highest rank across table columns

[sanjay dhal]

I m using a mysql table(say tbl_student_mar k) which have the data id,student_name ,mark_physics,m ark_chemistry,m ark_biology....
I have to find the name of 3rd Heighest scrorer across the table
Can any one help me??

[Rabbit]

You can join the table to itself to create a ranking query by using the aggregate count to find the third such student.