How to find out the second largest element from mysql table
Answer Posted / prasad
select id from tbl_name order by id desc limit(1,1)
(selects 2nd highest id)
for nth highest
select id from tbl_name order by id desc limit(n-1,1)
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
How do I copy an entire mysql database?
What is RMS Migrations
What is meant by mysqli?
How do I download mysql on my laptop?
How do I declare a variable in mysql?
What are mysql functions?
What is max_used_connections in mysql?
What is mysql primary key?
What is mysql optimization?
What is bigint in mysql?
What is logs in mysql?
What is save point in mysql?
What are the technical features of MySQL?
Is mysql a nosql database?
how can you test for null values in a database? : Mysql dba