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

Are all views updatable ?

1151

Explain what is “asynchronous” communication in sql server service broker?

917

What is the default order of an order by clause?

988

How to delete all rows with truncate table statement in ms sql server?

999

What are the differences between char and varchar in ms sql server?

1060

What are the 2 types of classifications of constraints in the sql server?

1119

Can another user execute your local temporary stored procedures?

981

What information is maintained within the msdb database?

974

Tell me what are the essential components of sql server service broker?

939

How to insert data into an existing table?

975

What is difference between join and natural join?

961

Mention the differences between having and where clause.

1055

Does group by or order by come first?

954

What is use of attribute hierarchy ordered ? : sql server analysis services, ssas

1011

How many primary keys are possible in a table?

922