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

Can group by and orderby be used together?

1015

What are cursors and when they are useful?

1089

Explain system views?

1089

What is full outer join in sql server joins?

1068

How connect excel to sql server?

998

What happens when the SQL Azure database reaches Max Size?

111

Are all views updatable ?

1152

What are the benefits of normalization?

1109

What is normalization and its types?

1036

Can primary key be a foreign key?

1058

What is the difference between for xml raw and for xml auto?

1032

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1081

Distinguish between nested subquery and correlated subquery?

1045

What are the types of resultset?

967

Is foreign key unique?

998