select max(mark) from student where mark not in (select max (mark) from s

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

Question Posted / koti,khammam

Answer Posted / koti,khammam

select max(mark) from student where mark not in (select max
(mark) from student)

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the differences between stored procedure and view in sql server?

1159

IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1756

What are the advantages of log shipping?

929

Do you know how to implement service broker?

885

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1033

Do you know nested transaction?

905

How to provide default values to stored procedure parameters?

1003

Explain time data type in sal server 2008?

870

What is view in sql?

853

what is a traditional network library for sql servers? : Sql server database administration

893

Can you explain different types of joins?

885

Explain temporary table vs table variable by using cursor alternative?

943

Where are full-text indexes stored?

945

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1131

What is the difference RDBMS and Graph Database?

1004