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

How to concatenate two binary strings together?

1048

Explain system rowset functions?

937

What is the command to change the recovery model?

999

In which files does sql server actually store data?

852

How to get a list of columns in a view using the "sp_columns" stored procedure?

985

How to create stored procedures with parameters in ms sql server?

991

What are sql servers used for?

980

How are the unique and primary key constraints different?

1003

What are the difficulties faced in cube development? : sql server analysis services, ssas

997

Explain what are the authentication modes in sql server?

945

What is the impact on other user sessions when creating indexes?

873

How to convert a unicode strings to non-unicode strings?

1029

What is the difference between online clustering and Offline clustering?

2356

Explain the functionalities that views support?

1044

How to verify a user name with sqlcmd tool?

1020