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

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

Please Help Members By Posting Answers For Below Questions

How do I start sql server?

966

What happens if null values are involved in boolean operations?

985

List few advantages of stored procedure.

981

What is the difference between stored procedure and functions?

1126

What are the events recorded in a transaction log?

993

What are the advantages of stored procedure in sql server?

890

When cursors are useful?

1094

How to find out the list schema name and table name for the database?

935

How do I port a number to sql server?

1032

How to connect of datebase with sql express.?

1094

State the difference between union and union all?

926

What is SQL Server?

1203

Does sql server 2016 have ssms?

954

What are the kinds of subquery?

1008

What are different types of database indexes?

1091