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

What is table-valued sub query?

924

Do you know what are the properties of the relational tables?

983

What happens if ntwdblib.dll is missing on your machine?

1101

What are points to remember while using the fillfactor argument?

909

What is the exact numeric data type in sql?

962

Is sql different from sql server?

1003

Define compound operators?

862

What is a deadlock and what is a live lock?

951

What is the difference between sdf and mdf?

1234

How do I run a trace in sql server?

932

What is the default schema of your login session in ms sql server?

996

How many primary keys are possible in a table?

875

What are the underflow and overflow behaviors on float literals?

1061

How much is a sql server license?

904

What is advantage data architect?

868