select max(mark) from student where mark < (select max (mark) from stud

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

Question Posted / dolat ram

Answer Posted / dolat ram

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

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is data source view or dsv? : sql server analysis services, ssas

949

How does clustered and non clustered index work?

851

How to use copy and concatenate commands in SQL?

1066

What are three major types of constraints?

1048

What is the default value of an integer data type in sql server 2005?

912

Can I work with several databases simultaneously? : sql server management studio

945

Explain about SQLOS?

948

what is sql server? : Sql server database administration

929

How do triggers work?

882

What is sql collation?

1139

What triggers long term care?

991

Show Practically Sql Server Views are updatable?

1056

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

932

How to count rows with the count(*) function in ms sql server?

951

What is subquery in sql?

989