select max(mark) from student where mark < (select max (mark) from stud

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

Question Posted / dolat ram

Answer Posted / dolat ram

select max(mark) from student where mark < (select max
(mark) from student)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How many levels of sp nesting is possible?

795

What does it mean to manipulate data?

743

How to use order by with union operators in ms sql server?

753

what protocol both networks use? : Sql server database administration

715

What are the 10 characteristics of data quality?

679

How to find the list of fixed hard drive and free space on server?

782

What is replication with database mirroring? : sql server database administration

701

What are the different types of columns types constraints in the sql server?

735

How can I get data from a database on another server?

687

Can you explain important index characteristics?

690

Tell me what are the advantages of using stored procedures?

743

List types of tables in SQL Azure?

120

Can you index views?

672

What are data resources?

659

Explain the types of indexes.

834