I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / suman
select max(mark) from student where mark <
(select max(mark)from student)
Is This Answer Correct ? | 5 Yes | 3 No |
Post New Answer View All Answers
What is merge join?
How to create a view using data from another view?
What are different backups available in sql server?
what is a correlated sub-query? : Sql server database administration
Explain trigger classes i.e. Instead of and after trigger?
What do you mean by a dependent functionality in a build?
List out a number of the wants to setup a SQL Server failover cluster?
How to provide column names in insert statements in ms sql server?
How do you drop an index?
What are translations and its use? : sql server analysis services, ssas
How do I create a stored procedure in dbml?
What are the differences between sql server and mysql.
What are the differences between substr and charindex in sql server.
What is rs.exe utility?
What is service broker?