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

What is the purpose of a table?

994

Tell me can we use custom code in ssrs?

1054

How to get the definition of a trigger back?

1045

How to get a list of columns in a view using "sys.columns" in ms sql server?

1040

What are constraints in microsoft sql server?

1215

What is a transact-sql statement batch in ms sql server?

1071

What is RMS migrations?

2191

What are clustered and non-clustered index?

1049

How to create a store procedure with encryption?

1054

What are xml indexes?

1003

what is normalization? : Sql server database administration

1161

What are a scheduled jobs?

990

What is spid in sql server profiler?

1168

What is 5nf in normalization form?

1044

What are the disadvantages of using the stored procedures?

1186