SELECT MAX(marks) AS second_highest_mark FROM student WHERE marks

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

Question Posted / lokeshwaran s

Answer Posted / lokeshwaran s

SELECT MAX(marks) AS second_highest_mark
FROM student
WHERE marks < (SELECT MAX(marks) FROM student);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is difference between clustered and non clustered index?

702

List types of tables in SQL Azure?

120

Do you know hot add cpu in sql server 2008?

727

What is a matrix in ssrs?

119

What is resultset concur_updatable?

743

Describe different Processing Modes offered by SSRS?

202

What do you mean by a Composite primary key?

759

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

292

What are the elements of dbms?

711

What xml support does the sql server extend?

724

What is the full form of ddl?

664

What is the default sql server instance name?

751

How do I debug a stored procedure in sql server?

726

What is the difference RDBMS and Graph Database?

802

How to configure odbc dsn with different port numbers?

754