I have student marks in a student table. I need all record where second h

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

Question Posted / shrikant

Answer Posted / shrikant

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

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to turn off warning messages during php execution?

1043

Explain the microsoft sql server delete command?

1015

Explain primary key and foreign key constraints?

1029

How to provide login information for a new odbc dsn?

1050

How to return the top 5 rows from a select query in ms sql server?

1132

Explain DBCC?

958

How many types of attribute relationships are there? : sql server analysis services, ssas

1070

Can a database be shrunk to 0 bytes, if not, why?

1099

Explain how you can deploy an SSRS report?

149

What is the maximum number of instances in 32 bit and 64 bit sql server 2012?

975

Why should you use or avoid select * statements?

1023

Define tempdb database?

992

What languages bi uses to achieve the goal?

1002

How to delete an existing row with delete statements in ms sql server?

1087

Can we insert data if clustered index is disabled?

939