How to find out the second largest element from mysql table
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
What are the types of database engines available in mysql?
How do I save in mysql?
What is ibdata1?
How do I rename a mysql database?
what is the default port for mysql server? : Mysql dba
What is processlist in mysql?
Where is mysql used?
Is mysql port 3306 tcp or udp?
What are the differences between mysql vs sql server?
What is full form of xampp?
What is the current mysql version?
What is the difference between a database and a table?
What causes mysql too many connections?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
How many groups of data types?