select a.marks from student a where(select count(b.marks) from student b w

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

Question Posted / jyoti bikash panda

Answer Posted / jyoti bikash panda

select a.marks from student a where(select count(b.marks)
from student b where a.marks<=b.marks)=2

Is This Answer Correct ?

2 Yes

2 No

Please Help Members By Posting Answers For Below Questions

How to convert binary strings into integers in ms sql server?

1025

What is logon trigger?

1089

What is the difference between dataadapter and datareader?

1001

Where sql server user names and passwords are stored in sql server? : sql server database administration

1048

How to get a list of all tables with "sys.tables" view in ms sql server?

1032

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

1028

How to convert a table data in XML format in sql server?

2539

Explain a checkpoint?

1028

What do you understand by check constraint in sql server?

943

How can you find out which stored procedures are recompiling?

916

What is ssrs?

129

What is the difference between push and pull subscription? : sql server replication

1211

What do you understand by recursive stored procedures?

986

Explain how to integrate the ssrs reports in application?

1009

Define model database?

970