How to find out the second largest element from mysql table
Answer Posted / lekhraj deshmukh
select marks from tbl_data where marks<(select max(marks)
from tbl_data) order by marks desc limit 1;
Is This Answer Correct ? | 21 Yes | 11 No |
Post New Answer View All Answers
What is the maximum number of records in mysql table?
What is mysql_query?
Does mysql use t sql?
How large can a mysql database become?
How to do login in mysql with unix shell.
Is mysql same as sql?
Which mysql function is used to concatenate string?
How do I view mysql logs?
What are the functions of mysql?
Is mysql good for big data?
what is constraints? Also explain the different types of constraints?
What are the difference between now and current_date in mysql?
Why mysql is used with php?
Why do we use views instead of tables?
How do I copy a table in mysql workbench?