How to find out the second largest element from mysql table
Answer Posted / prashant chaudhary
select top 1 * from ( select top 3 * from Student_Info
order by marks desc)table1 order by marks
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
What is the purpose of using a heap table?
Write a query to select all teams that won either 1, 3, 5 or 7 games.
What is auto increment in mysql?
Is null in mysql?
How to get a list of all tables in a database?
using primary can we relate two table, with out foreign key?
How to store binary data in mysql?
What is InnoDB?
What is the difference between mysql and sql?
Is mysql connect deprecated?
How can we run batch mode in mysql?
what is the difference between between and in operators in mysql?
What are the advantages and disadvantages of using mysql?
What are the similarities between a function and a procedure?
How do I create a mysql database?