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

Explain the different index configurations a table can have?

885

What are click through reports?

138

Explain alternate key, candidate key and composite key in sql server?

860

What is the maximum size of sql server database?

944

What are the dmvs?

950

Which is better statement or preparedstatement?

868

What are the methods used to protect against sql injection attack?

999

What is normalization? Explain different forms of normalization?

1069

What is the maximum size of a row in sql server?

904

What is failover clustering overview?

1020

What do you understand by a stored procedure?

1038

How many types of cursor type are there?

1012

Which is the main third-party tool used in sql server?

882

Write an SQL query to obtain the 2nd highest salary.

1018

How to create a store procedure with encryption?

949