Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

I want query to find the students name who have second highest marks in a table

Answer Posted / ashu

SELECT Max(Marks) FROM student_marks WHERE < ( SELECT Max(Marks) FROM student_marks)

By this query I am getting 2 nd highest marks but how to get the student name?

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board

1507


hi. i m Anil patel when reconcile 57f4 chalan(subcontraction with out excise)i m facing error like short by material 220 kg. even i have migo all material.

1690


what is new g/l functionality

1831


what is the instrument that used in Mechanical Energy??

1929


mount: mount to NFS server failed: System Error: Connection timed out

2905