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

How you trouble shoot when any job fails

1941

What is self contained multi valued query?

1025

Relational calculus is what type of language?

1046

Mention what are the core components of ssrs?

323

How can i Relate Tables in SSIS

1088

what is the difference between count(*) and count(1) ?

1091

What is cursors? And what are the different types of cursor?

1148

What is the minimum recommended amount of ram for sql server 2012 enterprise?

942

What are recommended options to be used while using db mirroring? : sql server database administration

1168

What are the difference between “where” and “having” clause in sql server?

1080

How do I start and stop sql server?

1034

What is a trigger and its types?

996

Can group functions be mixed with non-group selection fields in ms sql server?

952

Is the primary key column of a table an index in ms sql server?

966

Explain what is the purpose of sql profiler in sql server?

1087