How to find out the second largest element from mysql table
Answers were Sorted based on User's Feedback
Answer / neelesh jain
LIMIT <n> == n rows will be returned
OFFSET <n> == skip n rows of the query result
SELECT Salary FROM Employee ORDER BY Salary DESC LIMIT 1
OFFSET 1;
so above query skip 1 element (as offset is 1), which is
biggest and returned 1 elemetn which is 2nd largest value.
Is This Answer Correct ? | 0 Yes | 0 No |
SELECT salary
FROM employees
ORDER BY salary DESC
LIMIT 2,1
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prashant chaudhary
select top 1 * from ( select top 3 * from Student_Info
order by marks desc)table1 order by marks
Is This Answer Correct ? | 5 Yes | 6 No |
Answer / 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 |
Answer / sivsankar.ponnurangam
select project_id from tbl_project order by project_id
desc limit 2,1
Is This Answer Correct ? | 21 Yes | 42 No |
Is mysql still relevant?
How can I compare two mysql databases?
What are the different tables present in MySQL?
How do I restore a mysql database dump file in linux?
What is meant by mysql database?
Which statement is used to delete a table in MySQL.
What is mysql primary key?
How to enter microseconds in sql statements?
Can you rename a database in mysql?
Explain the different types of constraints?
How can we encrypt and decrypt a data presented in a table using mysql?
What is the default port number of mysql?