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

explain extended properties

991

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1607

When columns are added to existing tables, what do they initially contain?

1034

how you can move data or databases between servers and databases in sql server? : Sql server administration

966

What is multilevel indexing?

929

What is the difference between system objects and user objects?

1163

How can you tell if a database object is invalid?

1074

How to generate create function script on an existing function?

1118

What is subquery? Explain the properties of a subquery?

988

Explain syntax for disabling triggers?

1044

What is factless fact table? : sql server analysis services, ssas

1031

Can sql servers linked to other servers like oracle?

953

Mention the differences between local and global temporary tables.

1043

What is set nocount on and what is set nocount off?

934

What is the difference between Clustered and Non-Clustered Index?

1059