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 extended events?

1062

What are dml triggers and types of dml triggers?

1028

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1000

What Are the Main Features of SQL Azure?

121

Explain what are the different index configurations a table can have?

1160

How to select all columns of all rows from a table with a select statement in ms sql server?

1195

What are the drawbacks of reporting in ssrs?

159

What is system stored procedures?

1083

What is simple indexing method?

1083

When I run the sql server 2000 setup, it just hangs. What do I do?

1127

What do you think of this implementation? Can this be implemented better?

995

How do I get to sql server configuration manager?

1060

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1058

Difference between report and query parameter.

1144

Explain indexing and what are the advantages of it?

1070