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

Explain database normalization?

1215

Explain what are the restrictions while creating batches in sql server?

1065

Explain the ways to controlling cursor behavior?

914

Does group by or order by come first?

954

What is an identity?

1010

What does it mean to be in union?

931

What is it’s similarity with sql server?

160

What happens if the update subquery returns no rows in ms sql server?

1122

Â Explain what is sql override for a source taLle in a mapping?

1007

What are the 7 disadvantages to a manual system?

981

How will you add a dimension to cube? : sql server analysis services, ssas

1082

What are the types of database recovery models?

1115

How to find the second highest salary of an employee?

1172

Where to find ntwdblib.dll version 2000.80.194.0?

958

What programming language would you use to create embedded functions in ssrs?

184