I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 61304 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vikas kant
select Top 1 marks from students where marks in(select Top
2 marks from students order by marks desc)
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Create and insert into temp table in sql server?
What are rows and columns?
How to execute multiple stored procedures at one time in sql server?
Explain filtered indexes?
How do you handle datasets larger than 50 gb?
Which are the two editions in which SQL Azure database available?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
Define inner join in sql server joins?
Define Joins?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
How to create function without parameter in sql server?
Do you know what is a trace frag? Where do we use it?
What is a db view?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
