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

How can we convert between Unix & MySQL timestamps?

902

What is mysqlcheck do?

964

What are the method you will follow while sql installing

2316

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

948

How do stored procedures work?

954

what is database white box testing? : Mysql dba

940

Is mysql still relevant?

860

What is mysql optimization?

860

List the different types of normalization?

889

What is delimiter in mysql?

812

How do I connect to mysql database?

964

How you will Show unique records.

968

How do I completely remove mysql from windows?

916

How do I disconnect mysql workbench?

997

What does mysql_query return?

960