select top 1 marks from student where marks in(select distinct top 2 mark

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

Question Posted / sadaq moulani

Answer Posted / sadaq moulani

select top 1 marks from student where marks in(select
distinct top 2 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 dimension table? : sql server analysis services, ssas

1064

List all types of constraints in sql server?

1086

Explain candidate key, alternate key, and composite key?

1056

What is the purpose of forms?

1003

Name few endpoints exposed by ssrs 2012?

366

what is difference between NULL and ISNULL in SQL Server 2008?

1057

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

1077

Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?

2550

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1022

How do you check sql server is up and running?

1044

What is provisioning, billing and metering, and connection routing concepts in the service layer?

115

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

1057

what is sql server? : Sql server database administration

1040

Define candidate key, alternate key, and composite key.

966

What is the difference between a fill factor of 100 and 0?

1027