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

What is the difference between the 2 operating modes of database mirroring?

1055

what is the difference between Tabular and Matrix report?

160

how to overcome kernel isssues

1567

Explain the steps to create and execute a user-defined function in the sql server?

918

How to list all columns in a table using odbc_columns()?

934

What happens if null values are involved in arithmetic operations?

961

What gets stored inside msdb database?

1194

how to control the amount of free space in your index pages? : Sql server database administration

981

What are commonly used odbc functions in php?

970

How do you set a trace flag in sql server?

995

What is a schema in ms sql server 2005?

915

How to drop an existing stored procedure in ms sql server?

963

Can a database be shrunk with users active?

1062

Difference between Logical Page and Physical Page in SSRS.

459

Would you store your query in a ssrs report or a database server? State the reason why?

148