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

Should you normalize audio?

941

what type of index will get created after executing the above statement? : Sql server database administration

971

Where sql server usernames and passwords are stored in a sql server?

989

What is trace flag in sql server?

1018

Which are new data types introduced in sql server 2008?

1049

What is nonclustered index with included columns ?

965

How to enforce security in sql server? : sql server security

1104

Explain the ways to controlling cursor behavior?

917

How do I view a procedure in sql server?

987

What are the advantages of using stored procedures in sql server?

1011

How to include text values in sql statements?

1037

Explain use of expression builder.

1013

Name few endpoints exposed by ssrs 2012?

355

What are rest-style architecture's?

170

What happens to a trigger with multiple affected rows?

941