Interested to Buy Any Domain ? << Click Here >> for more details...
How to find out the second largest element from mysql table
- 15 Answers
- 27791 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
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?
