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

Explain the various types of concurrency problem?

1195

Write a program using SQL queries to find a unique entry in a table.

995

Sql server reporting services vs. Crystal reports.

132

How do I run a trace in sql server?

984

What is data file in computer?

947

Is oracle faster than sql server?

954

What is change tracking in sql server?

1025

Difference between report and query parameter. Why do we need different type of parameter?

959

Can we insert data if clustered index is disabled?

943

How do I know if localdb is running?

954

What is sub-query in sql server? Explain its properties.

1093

How to recover from sql injection? : sql server security

1018

Mention the different types of replication in sql server.

1026

How sql server enhances scalability of the database system?

1219

What are the advantages of using a stored procedure?

1008