Interested to Buy Any Domain ? << Click Here >> for more details...
How to find out the second largest element from mysql table
- 15 Answers
- 27999 Views
- I also Faced
- E-Mail Answers
Answer Posted / shanmukha
select min(salary) from Employee where salary in(select
distinct top 2 salary from Employee order by salary desc )
This is the query to find second maximum salary in MSSQL
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How many rows can a mysql table hold?
What is longblob?
How do I remove a user from mysql?
Is mariadb faster than mysql?
Does mysql case matter?
What is the purpose of mysql database?
How to validate email addresses in mysql?
How to create a new table in mysql?
Is mysql easy to learn?
How do I update a variable in mysql?
What is maximum table size in mysql?
What does the file with the extension: frm, myd, and myi contain?
List some mysql advantages and disadvantages?
What is session variable in mysql?
Explain the difference between delete and truncate.
