select max(mark) from student Having max(mark)<(select max(mark)

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

Question Posted / sarika

Answer Posted / sarika

select max(mark)
from student
Having max(mark)<(select max(mark)
from student)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain how would you store your query in an SSRS report or a Database server?

128

How to find the service pack installed? : sql server database administration

1023

What are different types of statements that are supported by sql?

1047

Do you know what are the restrictions that views have to follow?

1079

How to download microsoft sql server 2005 express edition?

1047

How you can add messages to the nt event log from within a stored procedure?

1069

Define union, union all, minus, intersect?

979

Explain the use of containers in ssis and also their types?

970

explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1099

What is a rownum?

978

Is there any difference between the primary key and unique key?

1001

What is primary key index?

979

What is the default Port No on which SQL Server listens?

1124

Mention a few common trace flags used with sql server?

931

What is a data source or ds? : sql server analysis services, ssas

1006