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

What are the different types of locks in the database?

918

How do you implement session management in SQL Server mode?

1095

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

1079

Explain what is lock escalation?

1058

Can we install sql server 2016 on windows 7?

1127

List all the types of user-defined functions?

1092

What is the web service used for reporting services?

123

what are the types of indexes? : Sql server database administration

1113

Tell me what are the advantages of using stored procedures?

1000

In which tcp/ip port does sql server run? Can it be changed?

985

How many instances per computer are there in sql server 2000?

1062

Does sql server use t sql?

1014

How to drop an existing table with "drop table" statements in ms sql server?

1084

What is serializable?

1037

What is table constraint?

985