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

Explain the different types of backups available in sql server? : sql server database administration

928

What is NOT NULL Constraint in sql server 2012?

1000

What are group functions in query statements in ms sql server?

1010

How to select an exiting database using mssql_select_db()?

989

What is the use of for clause?

1118

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

971

How can you know if the row fetched from cursor is still valid in underlying table?

998

Explain the Ways to improve the performance of a sql azure database?

Does sql server use java?

1076

Can we store videos inside the sql server table?

980

How do I setup a sql server database?

1076

What is the difference between mysql and mysqli?

1206

What is left outer join in sql server joins?

1042

What is precedence constraint?

983

List out the differences between global and local temp tables in sql server?

1062