SELECT * FROM `student` WHERE class='Six' ORDER BY mark DESC LIM

I have student marks in a student table. I need second
highest mark .Then what will the query for this?

Question Posted / aaaa

Answer Posted / aaaa

SELECT * FROM `student` WHERE class='Six' ORDER BY mark DESC
LIMIT 1,1

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is row_number function?

738

What is rtm version in sql server?

695

How to delete duplicate rows?

709

How can you list all the columns in a database?

711

What is the fillfactor concept in indexes?

721

Is resultset an interface?

716

What is data source document?

750

What is database mirroring?

753

If a table does not have a unique index, can a cursor be opened on it?

666

If user is owning any SQL Objects, can we drop that user

1808

You want to implement the one-to-one relationship while designing tables. How would you do it?

718

What are the new features in sql server 2016?

706

Name and describe few console utilities for ssrs?

264

Does transparent data encryption provide encryption when transmitting data across the network?

804

Do you know what are different types of replication in sql server?

735