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

Difference between primary key and clustered index?

591

Is sql server 2016 free?

606

How to count rows with the count(*) function in ms sql server?

615

How to create a user to access a database in ms sql server using "create user" statements?

616

How you can get the list of largest tables in a database?

613

What are different types of replication in sql server?

659

what is the different types of backups available in sql server? : Sql server database administration

578

Explain the concept of view and Types of views in SQL server?

706

What is the maximum number of index per table?

660

How to get the definition of a stored procedure back?

616

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

737

How do I find the query plan in sql server?

623

Do you know what is replace and stuff function in sql server?

579

What is the data type of time?

603

What is the recovery model? List the types of recovery model available in sql server?

558