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 should one not prefix user stored procedures with ‘sp_’?

1041

How many replicas are maintained for each SQL Azure database?

142

What is an inner join?

979

difference between Clustered index and non clustered index ?

989

What are filegroups in sql server?

1058

explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

2477

Tell me about joins in database system and explain each in detail.

1043

What are different types of data sources?

1011

what is a correlated sub-query? : Sql server database administration

939

What are binary string data types in ms sql server?

1284

Can we do dml on views?

951

Explain the xml support sql server extends?

1036

What are sql servers used for?

1043

Define right outer join in sql server joins?

1042

What is parameterized reports in ssrs ?

149