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

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

Question Posted / suman

Answer Posted / suman

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

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the purpose of floor function?

533

can you instantiate a com object by using t-sql? : Sql server database administration

513

How do I find the port number for sql server?

500

How to make remote connection in database?

590

What is a mixed extent?

587

Tell me what is the significance of null value and why should we avoid permitting null values?

547

Explain triggers?

555

What is collation sensitivity? Explain different types.

540

What happens if null values are involved in string operations?

552

What is the full form of dql?

506

What is change data capture (cdc) feature?

584

What does it mean to be in union?

515

ow to bring suspect mode datbase online from scratch

1398

Are semicolons required at the end of sql statements in sql server 2005?

565

Explain what are the database objects? : SQL Server Architecture

559