I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 61302 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kunal sain
select mark from student s
where 1=(select count(*) from student s1
where s1.mark<s.mark);
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
How do I run sql server 2014?
What is a collation?
What are the difference between primary keys and foreign keys?
What are the advantages of the mirroring?
What are drillthrough reports?
What do you mean by an execution plan? How would you view it?
How to create median function?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
What are the differences between substr and charindex in sql server.
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
What is read uncmmited?
How can you check the version of sql server?
How do I view a script in sql server?
Difference between Inner vs outer joins?
What are number line correlation administrators will use while working with a subquery?
