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

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

Question Posted / supriya

Answer Posted / supriya

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

Is This Answer Correct ?

10 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is the difference between seek predicate and predicate?

986

What is deploy, process and build? : sql server analysis services, ssas

1033

Define full outer join in sql server joins?

912

What is database mirroring?

1037

What is BLOCK statements in SQL?

1205

what is raid? : Sql server database administration

968

How do I start sql server?

923

How you can minimize the deadlock situation?

979

What is meant by Active-Passive and Active-Active clustering setup?

1067

What are the different index configurations a table can have?

897

Why people hate cursor?

1094

What is onf in normalization form?

998

How to replace the Query Result 'Null Value' with a text ?

970

Explain the collation?

1043

What is named query? : sql server analysis services, ssas

907