I want query to find the students name who have second highest marks in a table
- 1 Answers
- 724 Views
- I also Faced
- E-Mail Answers
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
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.
what is the instrument that used in Mechanical Energy??
what is new g/l functionality
mount: mount to NFS server failed: System Error: Connection timed out
how can i get the question papers of year 2006 and 2007 of 12th commerce gujarat board
