How to find out the second largest element from mysql table
- 15 Answers
- 24861 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
Define REGEXP?
How important is to list the column names when doing an insert?
Can we save images in mysql database?
What is InnoDB?
Is oracle mysql free?
What is triggers and how it can be used in mysql?
What is max connection in mysql?
What does blob mean in mysql?
How do I show users in mysql?
What are the functions of commit and rollback statements?
How many ways to get the current time?
What is the limit of mysql database?
What you can use regular expression for in mysql? Support your answer with an example?
How to create table show example
Why use mysql procedures?
