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 deploy, process and build? : sql server analysis services, ssas

1103

What are security principals used in sql server 2005?

982

How to make a column nullable?

1109

Explain what are the database objects? : SQL Server Architecture

1077

What is the difference between nvl and nvl2?

953

What is the contrast between sql and mysql?

1110

What is onf in normalization form?

1054

What is store procedure? How do they work? When do you use?

940

How do I find the sql server version?

1022

Can we use where clause in union?

1064

What are three major types of constraints?

1115

How to assign null values to variables or columns?

969

How many levels of sp nesting are possible?

1021

How do I setup a local sql server database?

1004

Explain the purpose of indexes?

976