select marks from tbl_data where marks<(select max(marks) from tbl

How to find out the second largest element from mysql table

Question Posted / lekhraj deshmukh

Answer Posted / lekhraj deshmukh

select marks from tbl_data where marks<(select max(marks)
from tbl_data) order by marks desc limit 1;

Is This Answer Correct ?

21 Yes

11 No

Please Help Members By Posting Answers For Below Questions

How to start mysql server?

1043

Does mysql need a server?

921

Explain timestamp?

963

Why do we use preparedstatement?

910

Why do we write stored procedures?

916

What is auto increment in mysql?

956

What is 'mysqlimport'?

924

How does triggers work in mysql?

952

Is mysql a nosql database?

1116

What is unique key in mysql?

981

What are the differences between a primary key and foreign key?

1087

What is mysqlcommand?

991

What is append query?

908

What is difference between mysql and mariadb?

1110

How to present a past time in hours, minutes and seconds?

1040