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

How connect excel to sql server?

994

What are SSL and TSL protocols?

978

System requirements for sql server 2005 express edition?

1009

What are the triggers in sql?

1098

What is best institute to Learn DotNET And SQL in chennai?

2161

Differentiate between ms sql server reporting services vs crystal reports?

896

How many types of built in functions are there in sql server 2012?

922

What are the results of running this script?

920

What is ddl command?

969

Please explain go command in sql server?

1046

What are page splits?

995

What is precedence constraint?

978

What do you understand by the data quality services in sql server?

945

What is the query and subquery?

1075

what do you understand by change data capture?

1004