Member Avatar for GuruMS

hi friends I have student Table In This student Table I Want Know The Third Highest Mark
(I Want To Select Only The Third Highest Marks In The Student Table) Tell Me How To Write Query For That

Student_Table.jpg 20.04 KB
  • 2 Contributors
  • 1 Reply
  • 58 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for smantscheff

How do you want to learn anything if you don't even try?
If this is really a MySQL question, use the LIMIT clause in your query.
If it is standard SQL, use something like

SELECT * from Students A WHERE (SELECT count(*) FROM Students B WHERE A.marks < B.marks) = 2
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.