SELECT TOP 1 Marks (SELECT TOP 2 Marks from Tablename Order by Marks Desc

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

Question Posted / dharmendra k. dixit

Answer Posted / dharmendra k. dixit

SELECT TOP 1 Marks (SELECT TOP 2 Marks from Tablename Order
by Marks Desc)From Tablename order by Marks Asc

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what do you understand by change data capture?

1025

What is an indexed view?

960

How to replace given values with null using nullif()?

992

How to declare and use cursor variables?

1172

Explain multiserver query

1046

What is data set in report?

135

Can we delete data from a view?

925

Write a SQL command to insert and update only a particular field?

1112

Explain what are page splits? : SQL Server Architecture

1066

What is a non equi join?

982

What is trace flag in sql server?

1026

what protocol both networks use? : Sql server database administration

972

What is a trace frag?

1086

How to use copy and concatenate commands in SQL?

1143

Can we call future method from queueable?

1053