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 / pravin more

Answer Posted / pravin more

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

Is This Answer Correct ?

53 Yes

14 No

Please Help Members By Posting Answers For Below Questions

How do I know if localdb is running?

999

Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1125

What is the use of floor function in sql server?

1127

What is update locks?

935

what is an extended stored procedure? : Sql server database administration

1109

How can we rewrite sub-queries into simple select statements or with joins?

1028

Why use update_statistics command in sql server?

1113

Explain the steps to use transact-sql cursor?

1155

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

959

What is the difference between delete and truncate statements?

1127

What do you need to connect php to sql server?

1154

Can you name a few encryption mechanisms in sql server?

991

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1040

Explain logical operators in sql server?

1183

Is there any difference between primary key and unique with the not null condition?

1001