I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 62937 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
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
Is null vs coalesce?
Can we call future method from queueable?
How would you go about developing a ssrs report?
What are partitioned views?
Can we use pragma autonomous_transaction in trigger?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?
what is a transaction and what are acid properties? : Sql server database administration
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
Difference between Inner vs outer joins?
How to select some specific rows from a table in ms sql server?
what are the different types of SSRS reports?
What are the acid properties?
How does clustered and non clustered index work?
