select top 1 marks from student where marks <(select max(marks) from stu

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

Question Posted / rajat kumar

Answer Posted / rajat kumar

select top 1 marks from student where marks <(select max(marks) from student) order by marks desc

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

1010

Can foreign key be duplicate?

1002

Why truncate is ddl command?

995

What is the difference between update lock and exclusive lock?

913

How to test subquery results with the exists operator?

1036

Is mysql better than sql server?

1005

What is the command dbcc checkdb used for?

966

What method is used by the Command classes to execute SQL statements that return single values?

1007

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

943

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

1453

What do you understand by sql server agent?

909

What do you understand by the data quality services in sql server?

903

How to delete a login name in ms sql server?

1005

Explain intellisense for query editing

980

What is ms sql server triggers?

946