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 will happen if a column containing char type data is changed to the nchar data type?

1146

plss anybody specify tha constrian management system in dbms

2202

What are the disadvantages of using the stored procedures?

1183

Tell me what is the difference between locking and multi-versioning?

1082

Explain aggregate functions?

1135

What are the different authentication modes in sql server?

1164

Explain filtered indexes?

1037

What is subquery in sql?

1119

What are four major operators that can be used to combine conditions on a where clause?

1090

When to use null data driven subscription?

213

What is difference between inner join and full join?

1106

What is "scheduled jobs" or "scheduled tasks"?

1024

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

1070

Define tempdb database?

1037

What is transaction server auto commit?

1111