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

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

Question Posted / suman

Answer Posted / suman

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

Is This Answer Correct ?

5 Yes

3 No

Please Help Members By Posting Answers For Below Questions

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

909

What do you mean by an execution plan? How would you view it?

914

What is the difference between a unique key and primary key?

956

What is the use of stored procedure?

941

Explain what is lock escalation and what is its purpose?

932

How do you delete duplicate rows in sql server?

959

How do you Implement SSIS Packages in your Project?

1931

What is delete query?

941

Mention the different authentication modes in sql server.

1056

between cast and convert which function would you prefer and why?

956

What is a constant or literal in ms sql server?

1048

what is dbcc? : Sql server database administration

1035

What is difference between count (*) and count column?

904

Explain candidate key, alternate key, and composite key?

1003

If any stored procedure is encrypted, then can we see its definition in activity monitor?

992