select a.marks from student a where(select count(b.marks) from student b w

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

Question Posted / jyoti bikash panda

Answer Posted / jyoti bikash panda

select a.marks from student a where(select count(b.marks)
from student b where a.marks<=b.marks)=2

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the differences between triggers and stored procedures?

987

What is the purpose of the master database?

1050

How to deploy the Report?

125

What are orphan records?

885

what are constraints? Explain different types of constraints? : Sql server database administration

916

what is the main function of a query parameter?

140

What is stored in the mssqlsystemresource database? : sql server database administration

986

What is instead of dml trigger?

945

Define Joins?

971

What are the different types of replication you can set up in sql server?

979

What is acid properties?

1012

Can a table be moved to different filegroup?

917

What is normalization process?

1102

How to trouble shoot if unable to connect SQL Server

1921

What are different types of views?

891