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

How to find out the second largest element from mysql table

Question Posted / harish varma

Answer Posted / harish varma

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many columns can a mysql table have?

959

What are the different mysql database engines?

1236

What is latest version of mysql?

1078

What does innodb stand for?

1025

How we can see all indexes defined for a table in mysql?

1000

How do I stop a mysql command?

1057

How large can a mysql table be?

1016

What do you need to connect php to mysql?

1037

What is the current version of mysql?

1020

What is the query to display top 20 rows?

1071

How is oracle different from mysql?

1113

What is the difference between float and double?

1191

How triggers can be used in mysql?

1063

How to represent ENUMs and SETs internally?

1169

Is mysql running ubuntu?

1062