select top 1 * from (select top 2 marks from student order by marks desc)a

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

Question Posted / maheswar reddy s

37 Answers
68776 Views
NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
E-Mail Answers

Answer Posted / maheswar reddy s

select top 1 * from (select top 2 marks from student order by marks desc)a order by marks

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is a traditional network library for sql servers? : Sql server database administration

960

How to list all schemas in a database?

1064

How you can change the database name in SQL SERVER?

1194

How to send a ssrs report from ssis?

176

How to configure and test odbc dsn settings?

1160

Call by value and call by reference in procedure and function, with NOCOPY.

1306

create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

956

Please explain what is “asynchronous” communication in sql server service broker?

939

How to turn on the mssql api module in php?

1080

What are the different sql server versions?

983

How do you create an execution plan?

952

what protocol both networks use? : Sql server database administration

974

What is difference between line feed ( ) and carriage return ( )?

910

What are the different types of data sources in ssrs?

196

What are the different subsets of sql?

1552