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 can you change the name of any existing table by using the sql statement?
What is database url for mysql?
What is mysql database used for?
Explain about the architecture of MYSQL?
Why to use char instead of varchar in the database?
What is field in mysql?
What is difference between microsoft sql and mysql?
What you can use regular expression for in mysql? Support your answer with an example?
What is prepare statement in mysql?
how to Return total number of rows.
What is schema in mysql?
Which storage engine is best in mysql?
using primary can we relate two table, with out foreign key?
Is mysqli deprecated?
What does schema mean?