SELECT Salary FROM tablename order by Salary desc limit 1,1

How to find out the second largest element from mysql table

Question Posted / nikhil mishra

Answer Posted / nikhil mishra

Is This Answer Correct ?

24 Yes

11 No

Please Help Members By Posting Answers For Below Questions

Is mysql a backend?

968

What is sql in mysql?

1085

What is definer in mysql trigger?

973

What is data node in mysql cluster?

1027

What is mysql aggregate functions? Explain

1157

What are numeric data types?

1042

What causes mysql too many connections?

1030

What is mysql server?

1148

How many threads can mysql handle?

1036

How to check if value already exists in mysql database in php?

933

What are queries used for?

998

How can I compare two mysql databases?

1017

What is the storage engine for mysql?

1008

How to decrement dates by 1 in mysql?

1057

What is the current mysql version?

1069