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 type of locking occurs during the snapshot generation? : sql server replication

1333

What are pessimistic lock and optimistic lock?

1080

What do you understand by recursive stored procedure?

933

What are functions in the sql server?

1222

Explain about Normalization?

1069

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1082

What is the use of commit?

1002

Define normalisation?

1118

How to select some specific columns from a table in a query in ms sql server?

1005

What is a non equi join?

983

What is the difference between cube operator and rollup operator? : SQL Server Architecture

1128

How to filter out duplications in the returning rows in ms sql server?

1142

What is difference between count (*) and count 1?

932

How many types of keys are there?

1033

Explain database normalization?

1231