try using this... select top 1 from student where marks in (select top 2 f

I have student marks in a student table. I need second
highest mark .Then what will the query for this?

Question Posted / kumaravel

Answer Posted / kumaravel

try using this...
select top 1 from student where marks in (select top 2 from
student order by marks desc)

Is This Answer Correct ?

16 Yes

10 No

Please Help Members By Posting Answers For Below Questions

How can I create a report based on a query? : sql server management studio

1015

Tell me what do you understand by a view? What does the with check option clause for a view do?

1019

Why do we partition data?

1028

What is a trigger and types of a trigger?

980

What is the difference between a view and a stored procedure?

1037

What command is used to delete a table from the database in the sql server and how?

1113

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1099

What is a select query statement in ms sql server?

1073

You want to implement the many-to-many relationship while designing tables. How would you do it?

997

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

933

What is an inner join?

981

Do comments need to go in a special place in sql server 2005?

856

What is row_number()?

982

What is a print index?

882

What are constraints?

1006