select max(marks) from student where marks not in (select max(marks) from

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

Question Posted / supriya

Answer Posted / supriya

select max(marks) from student where marks not in (select
max(marks) from student)

Is This Answer Correct ?

10 Yes

7 No

Please Help Members By Posting Answers For Below Questions

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

469

How will you hide an attribute? : sql server analysis services, ssas

525

what is dbcc? : Sql server database administration

526

How you provide security to cube? : sql server analysis services, ssas

539

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1404

Can foreign key be deleted?

528

What is GUID in sql server?

641

What is msdb database? : SQL Server Architecture

540

What is the sql case statement used for?

559

Tell me what is a linked server?

564

How do I start sql server 2016?

525

How do I get to sql server configuration manager?

518

How to download and install sql server 2005 books online?

541

Can you pass expressions to stored procedure parameters?

504

Why we use the openxml clause?

544