How to find out the second largest element from mysql table

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

More MySQL Interview Questions

What is mysql default port number?

0 Answers  


What is the datatype for password in mysql?

0 Answers  


How do you shutdown a mysql database?

0 Answers  


How to validate email addresses in mysql?

0 Answers  


Is number a datatype in mysql?

0 Answers  


How to create a new view in mysql?

0 Answers  


Create table employee (eno int(2),ename varchar(10)) ?

0 Answers  


How to delete a column and add a new column to database

0 Answers  


What is row locking in mysql?

0 Answers  


Is mysql free for enterprise?

0 Answers  


How do I find mysql version in mysql workbench?

0 Answers  


Is oracle better than mysql?

0 Answers  


Categories