I have student marks in a student table. I need second
highest mark .Then what will the query for this?
Answer Posted / rajat kumar
select top 1 marks from student where marks <(select max(marks) from student) order by marks desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are distinctive joins find as a part of sql?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is a group function explain with an example?
What is logon trigger?
How do you use a subquery to find records that exist in one table and do not exist in another?
What is acid properties?
Explain what is analysis service repository?
How to turn on the mssql api module in php?
When we should use and scope of @@identity?
How many columns can exist together per table?
How to insert data into an existing table?
Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?
Can you type more than one query in the query editor screen at the same time?
What are the types of table?
What is database isolation in sql server? : sql server database administration