Select max(Marks) from Marks where Marks < (select max(Marks)from Marks

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

Question Posted / rupa

Answer Posted / rupa

Select max(Marks) from Marks where Marks <
(select max(Marks)from Marks)

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can we perform backup restore operation on tempdb?

1074

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

978

Tell me about builtinadministrator?

1045

What is user defined stored procedures?

993

Why are views required in the sql server or in any other database?

1001

How we create SQL Server 2005 Reporting Services ? Give me Sample

2043

What is the difference between seek predicate and predicate?

1108

what are the different ways to return the rowcount of a table?

1050

How many columns can exist together per table?

1208

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1384

How you can get the list of largest tables in a database?

1063

How to list all triggers in the database with sys.triggers in ms sql server?

1126

How to execute function in stored procedure sql server?

1231

What is the partitioning method?

1064

You want to implement the many-to-many relationship while designing tables. How would you do it?

1046