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 / pravin more

Answer Posted / pravin more

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

Is This Answer Correct ?

53 Yes

14 No

Please Help Members By Posting Answers For Below Questions

what is a live lock? : Sql server database administration

1010

Can we use where and having clause together?

1095

Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?

1026

What is data modification?

1015

what is a self join? : Sql server database administration

1115

What is cube dimension? : sql server analysis services, ssas

1043

How do you delete duplicate rows in sql server?

996

What are examples of triggers?

1123

What is Extended user-defined?

1025

What is full outer join in sql server joins?

1129

When would you use the stored procedures or functions?

1050

How to automatically create a log when an exception is being received into SQL Server?

1349

What is difference between drop truncate and delete?

1146

What is tempdb in sql server?

1021

Can one drop a column from a table?

1063