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

How do I run sql server 2014?

984

How retrieve field names from the table in SQL through JAVA code?

1905

Which table keeps information about stored procedures?

934

Explain the truncate command? : SQL Server Architecture

1166

What are the types of subscriptions in SQL Server replication?

1028

Detail about the hardware which is supported by SQL server?

1063

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

932

What can be used instead of trigger?

1156

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1260

What is sql server replication? : sql server replication

979

What is the difference between char and varchar2 datatype in sql?

1063

How to change the password of a login name in ms sql server?

1011

Explain ms sql server reporting services vs crystal reports?

911

How to disable triggers using "disable trigger"?

1056

What is sql server schema compare? How we can compare two database schemas?

1027