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

Is the order of columns in the set clause important in ms sql server?

929

What is sql server database?

939

What is a non-clustered index?

954

What is faster join or union?

1112

What are orphan records?

889

What is a primary index?

885

Do you know nested transaction?

907

Do you know what is difference between stored procedure and user defined function?

1034

How to set the current database in ms sql server?

1012

How to loop through returning rows?

975

What different steps will a sql server developer take to secure sql server?

933

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

905

List out what other servers you can use with ssrs?

130

How adventureworkslt tables are related?

882

Is port 1433 secure?

931