Interested to Buy Any Domain ? << Click Here >> for more details...
How to find out the second largest element from mysql table
- 15 Answers
- 28499 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 to create a new view in mysql?
Can mysql function return a table?
How does mysql store dates?
Which is faster mongodb or mysql?
What is data node in mysql cluster?
How can you calculate the sum of any column of a table?
What do I do if I forgot my mysql root password?
What is default password for mysql?
what is database white box testing? : Mysql dba
How do you insert a table?
How to use sum function in where clause in mysql?
What are the types of queries?
How to show table structure mysql?
How to include numeric values in sql statements?
What is mysql workbench used for?
