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 |
How do I install the latest mysql on ubuntu?
What is row locking in mysql?
What are the different types of triggers in mysql?
What are queries used for?
What is 'mysqldump'?
What is the difference between a Table and a View?
How do I change a procedure in mysql?
Which is faster mysql or mongodb?
How internally data stores in MyISAM and INNODB table types?
How would you backup and restore a big MySQL database? What are the advantages of the approach which you have taken over the others?
Is it possible to update a table value with out using update command?. if yes what is the reason, if no what is the reason?.
Is mysql open source?