select top 1 age from student where age<(select top 1 age from stude

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

Question Posted / naresh

Answer Posted / naresh

select top 1 age from student where age<(select top 1 age
from student where age<(select distinct max(age) from
student ))

Is This Answer Correct ?

3 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is data source object?

997

What are system databases into sql server (2005/2008) : sql server database administration

1003

Tell me what is use of except clause? How it differs from not in clause?

958

Does server sql treat char as a variable-length or fixed-length column?

1012

How to transfer a table from one schema to another?

993

What is the purpose of object explorer and its features? : sql server management studio

1200

What is indexing and its types?

1010

While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

1038

What is dirty read?

1076

What is resultset concur_updatable?

1015

Explain four layers of abstraction microsoft architectured?

147

Explain subquery and state its properties?

1036

What is standby servers? Explain types of standby servers.

992

What is bit data type?

1026

Why do we need different type of parameter?

1051