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 |
What is mysql default port number?
What is the datatype for password in mysql?
How do you shutdown a mysql database?
How to validate email addresses in mysql?
Is number a datatype in mysql?
How to create a new view in mysql?
Create table employee (eno int(2),ename varchar(10)) ?
How to delete a column and add a new column to database
What is row locking in mysql?
Is mysql free for enterprise?
How do I find mysql version in mysql workbench?
Is oracle better than mysql?