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

What is indexing in sql server with example?

1039

What is the difference between ddl,dml and dcl commands?

1156

What is SQL Server?

1271

What is a covered index?

987

What are data files?

1092

What is reference section?

1056

How to defragment table indexes?

1038

What number sorts of privileges are accessible in sql?

1087

hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.

2114

What are the five major components of a dbms?

961

What are the three different part of rdl file explain them?

276

What do you understand by replication in sql server?

1126

How to drop an existing table?

1052

Explain about sql server login?

1135

What happens if you delete a table that is used by a view?

1061