I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 61299 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / pravin more
select max(mark) from student where mark <
(select max(mark)from student)
| Is This Answer Correct ? | 53 Yes | 14 No |
Post New Answer View All Answers
List the ways in which dynamic sql can be executed?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
How to delete existing rows in a table?
What is a trigger and types of a trigger?
What is dynamic cursor in SQL SERVER?
What are the different editions available in sql server 2000?
how to determine the service pack currently installed on sql server? : Sql server database administration
how can a database be repaired? : Sql server administration
What is set nocount on and what is set nocount off?
What is cross join in sql server joins?
Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration
What is clustered primary key?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
Explain mixed authentication mode of sql server?
How to create a new table in a given schema?
