How to find out the second largest element from mysql table
- 15 Answers
- 24884 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 do I save in mysql?
How to upload a large file through phpmyadmin in mysql?
What is a mysql model?
What is mysql cursor?
What is inner join in mysql?
What are the advantages of mysql?
How would you enter characters as hex numbers?
Does mysql case matter?
Can you tell few best practices to be followed for optimization in sql?
What happens if you no create privilege in a database?
Where MyISAM table will be stored and also give their formats of storage?
Is mysql port 3306 tcp or udp?
How do I start mysql server?
How do you determine the location of mysql data directory?
How can we convert between Unix & MySQL timestamps?
