select top 1 * from ( select top 3 * from Student

How to find out the second largest element from mysql table

Question Posted / prashant chaudhary

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How set mysql root password?

965

What is general log in mysql?

1031

Why to use char instead of varchar in the database?

1265

What is database url for mysql?

1020

How to Creating a new user. Login as root. Switch to the MySQL db. Make the user. Update privs.

1063

List the different types of normalization?

989

What is timestamp in mysql?

1043

How can I create table in mysql?

1086

What is difference between schema and table?

963

What is field in mysql?

978

How show all tables in mysql query?

990

How you will Show unique records.

1067

what is constraints?

1231

What is difference between mysqli and pdo?

1001

What is mysqli procedural?

1002