How to find out the second largest element from mysql table
- 15 Answers
- 24883 Views
- I also Faced
- E-Mail Answers
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 are programming functions?
In mysql, what is the default storage engine?
What are the advantages of a procedure?
Does uninstalling mysql delete database?
How to shut down the server with 'mysqladmin'?
Can you tell a way to know the number of days between the two given dates in php?
how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.
Why is mysql used?
What is table level locking in mysql?
How to enter boolean values in sql statements?
What is row?
What is normalization and list the different types of normalization?
What is difference between mysql and mysql server?
What are the types of database engines available in mysql?
How to Change a users password from unix shell.
