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

Answer Posted / shrikant

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

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the concept of recursive stored procedure.

662


What do you mean by data integrity?

786


How to change the password of a login name in ms sql server?

710


How to recover from sql injection? : sql server security

699


What is Lock table in SQL?

1184






John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?

689


How to bind a view to the schema of the underlying tables?

754


What is difference between delete & truncate commands?

728


When would you use it?

756


What are different types of replication in sql server?

743


How to find out the list schema name and table name for the database?

707


What is the purpose of the master database?

812


What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

743


what are the different stages of Report Processing?

111


Does union all remove duplicates?

802