Select MIN(MARK) from student where mark in (select Top 2 mark from stude

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

Question Posted / rias

Answer Posted / rias

Select MIN(MARK) from student where mark in (select Top 2
mark from student order by mark desc)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Tell me what is difference between clustered and non clustered index?

944

What is de-normalization and what are some of the examples of it?

972

Explain nested join?

976

Tell me what is normalization? Explain different forms of normalization?

1028

Write the SQL query to drop, truncate and delete table.

969

What is the difference between nvl and nvl2?

951

What is the federation in sql azure?

How to insert multiple rows with a subquery?

1129

plss anybody specify tha constrian management system in dbms

2145

What are the differences between clustered and non-clustered index?

1027

What are four major operators that can be used to combine conditions on a where clause?

1041

What do you understand by check constraint in sql server?

945

What structure can you implement for the database to speed up table reads?

1195

What is difference between delete and truncate commands?

1075

What are different types of raid configurations? : SQL Server Architecture

1075