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 the difference between Tabular and Matrix report?

170

What is the difference between functions and scalar functions?

1212

How to include date and time values in sql statements?

1086

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

972

What’s the use of custom fields in report?

944

What do you mean by cardinality?

903

Where do we use trace frag?

1017

How to copy data from one table to another table?

996

What is meant by dirty read?

996

Can we insert data into view sql server?

932

Describe and explain about SQL native client?

1109

How to specify the collation for a character data type in ms sql server?

1030

What is intellisense?

1053

Explain acid?

1084

What is surrogate key? : sql server analysis services, ssas

1109