select max(marks) from studentmaster where marks

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

Question Posted / appalanaidu

Answer Posted / appalanaidu

select max(marks) from studentmaster where marks < (select max(marks) from studentmaster)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain the rules for designing files and file groups in sql server?

988

What is partition index in sql server?

1120

What is repeatable read?

1020

What is a View ? Can we insert, Update and delete a view?

995

What is user-defined inline table-valued function?

954

How can a database be repaired?

989

What are types of storage modes? : sql server analysis services, ssas

1042

what information is maintained within the msdb database? : Sql server administration

976

How do you create a clustered index?

1056

What is dirty page?

973

How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

1916

What are indexers?

1086

Why can there be only one clustered index and not more than one?

1005

What is a derived table?

928

How do I schedule a sql server profiler trace?

981