How to find out the second largest element from mysql table
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
What is mysql community server?
What is mysql data directory?
How can we run batch mode in mysql?
What happens if null values are involved in expressions?
What is the usage of regular expressions in mysql?
What is save point in mysql?
Is mysql a programming language?
What is a csv table?
what is the default port for mysql server? : Mysql dba
What is mysqli_result?
What are Heap tables?
What is auto increment in mysql?
What are programming functions?
How to calculate the difference between two time values?
What is a result set object?