How to find second total high mark from student table?

Question

Hello everyone I want to find second total high mark for student. Here Id is student Id.

Midhun T P · Answer

Hi Please try below query - SELECT * FROM( SELECT ids1+s2+s3 AS totalRANK() over(order by (s1+s2+s3) desc)Rank FROM tablename )e WHERE rank=2 Please have a look at below article to know more about rank() & dense_rank() functions- http://www.besttechtools.com/articles/article/sql-rank-functions