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

How to handle error or exception in sql?

980

How use inner join in sql server?

1130

What is a collation?

1088

How to enter date and time literals in ms sql server?

1012

Write an sql query to sort a table according to the amounts in a row and find the second largest amount.

920

When you should use a low fill factor?

990

What is an etl file?

953

Why variables called the most powerful component of ssis?

1075

Can a unique index be created on a column, which contains null?

917

Who developed sql server?

934

How to stop a loop early with break statements in ms sql server?

1018

What is the filtered index?

1052

Explain various data region available in ssrs with their use?

931

How to execute stored procedure and set temp table in sql server?

1038

What is a print index?

882