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

Is mysql still relevant?

0 Answers  


How can I compare two mysql databases?

0 Answers  


What are the different tables present in MySQL?

0 Answers  


How do I restore a mysql database dump file in linux?

0 Answers  


What is meant by mysql database?

1 Answers  


Which statement is used to delete a table in MySQL.

0 Answers  


What is mysql primary key?

0 Answers  


How to enter microseconds in sql statements?

0 Answers  


Can you rename a database in mysql?

0 Answers  


Explain the different types of constraints?

0 Answers  


How can we encrypt and decrypt a data presented in a table using mysql?

0 Answers  


What is the default port number of mysql?

0 Answers  


Categories