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

Explain comment on transactions?

1005

How to provide values to user defined function parameters?

1010

What is triggers in ms sql server?

1121

What is a livelock?

971

What is inline table-value user-defined function?

1116

Mention a few common trace flags used with sql server?

936

Why we use the openxml clause?

1016

How to create a large table with random data for index testing in ms sql server?

1031

What are the default system databases in sql server 2000?

1034

How do you make a trace?

1028

What are out-of-range errors with date and time literals?

1033

What is the order by used for?

1024

What is subquery in sql?

1072

What are the mathematical functions supported by sql server 2005?

1071

How to use subqueries with the in operators in ms sql server?

1077