How to find out the second largest element from mysql table

Categories >> Software >> Databases >> MySQL
Suggest New Category

Question Posted / rakesh kumar nautiyal

15 Answers
28966 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to find out the second largest element from mysql table..

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

How to find out the second largest element from mysql table..

Answer / harish varma

SELECT salary
FROM employees
ORDER BY salary DESC
LIMIT 2,1

Is This Answer Correct ?

0 Yes

0 No

How to find out the second largest element from mysql table..

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

How to find out the second largest element from mysql table..

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

How to find out the second largest element from mysql table..

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

Post New Answer