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

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

Question Posted / sarika

Answer Posted / sarika

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

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is updatable resultset?

522

Which tcl commands are available on the sql server?

611

How does normalization work?

513

Explain the disadvantages/limitation of the cursor?

568

If a table does not have a unique index, can a cursor be opened on it?

518

Define model database?

581

Please explain go command in sql server?

607

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

657

How do you set a trace flag in sql server?

566

Define Business Edition in SQL Azure?

What is data source in connection string?

497

What are key constraints?

520

How to locate and take substrings with charindex() and substring() functions?

518

what type of index will get created after executing the above statement? : Sql server database administration

546

How do you create type- insensitive operator?

574