How to find out the second largest element from mysql table
- 15 Answers
- 26157 Views
- I also Faced
- E-Mail Answers
Answer Posted / prashant chaudhary
select name,marks from Student_Info where marks = (select
max(marks) from Student_Info where marks <
(select max(marks)from Student_Info ))
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
How triggers can be used in mysql?
How do I view a mysql database?
How do you flush privileges?
How to get nth highest salary from table in a mysql?
using primary can we relate two table, with out foreign key?
Describe mysql transaction properties.
How many columns can a table have?
What is mysql server?
What is mysql connection limit?
What is query log in mysql?
What is procedure in mysql?
What is mysql sleep process?
How do I use mysql?
Is mysql a relational database?
How do I clear a mysql database?
