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 does dml stand for?

907

Explain why variables called the most powerful component of ssis?

995

List the different types of joins?

929

If user is owning any SQL Objects, can we drop that user

2010

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

885

When cursors are useful?

1038

What happens if null values are involved in datetime operations?

907

What is the difference between seek predicate and predicate?

988

How to run queries with sql server management studio express?

1022

How to execute a sql statement using odbc_exec()?

1061

How to verify a user name with sqlcmd tool?

1023

Write a code to select distinct records without using the DISTINCT keyword.

1052

What are the steps to process a single select statement?

889

What are the 7 disadvantages to a manual system?

909

What is table value parameters (tvp)?

1039