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

What is the Difference Between Primary and Foreign Key?

1066

What is subreport?

144

What are transactions and its controls?

1105

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

1045

Types of Authentications in Sql Server? How user gets authenticated through windows authentication?

1099

How can you list all the columns in a database?

970

Does transparent data encryption provide encryption when transmitting data across the network?

1099

What are user-defined functions (udfs) in sql server?

1051

What are different types of raid levels?

1237

Explain trigger and trigger types?

1037

can you instantiate a com object by using t-sql? : Sql server database administration

1043

What are the different types of stored procedures?

1155

How to declare a cursor with "declare ... Cursor" in ms sql server?

1093

Can we insert data if clustered index is disabled?

986

What is the use of commit?

1061