select max(mark) from student where mark not in (select max (mark) from s

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

Question Posted / koti,khammam

Answer Posted / koti,khammam

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

Is This Answer Correct ?

1 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Why is replication required on the sql server?

769

Explain datetime2 data type in sal server 2008?

704

Can you explain what is indexed view? How to create it?

717

What is analysis service repository?

766

You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

105

John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

689

What is key attribute?

699

What is thr feature of change data capture?

671

What happens if null values are involved in datetime operations?

703

What is log cache in sql server?

712

Explain raiserror in sql server?

749

what happens on checkpoint? : Sql server database administration

696

What is logon trigger?

716

What is create command?

698

Define indexes?

795