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

Define views.

681

role of sql sever 2005 in database rather than any other database

1594

Which table keeps information about stored procedures?

615

Explain what is use of dbcc commands?

598

Benefits of Stored Procedures?

647

Tell me the difference between clustered and non-clustered index?

597

Do comments need to go in a special place in sql server 2005?

590

Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

603

What are cursors in ms sql server?

694

how to do partition in sqlserver

2052

What is the use of partition by in sql server?

589

what is memory-optimized nonclustered indexes

649

How to include date and time values in sql statements?

705

Explain how many normalization forms?

656

whats the maximum size of view state??

1814