Interested to Buy Any Domain ? << Click Here >> for more details...
I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 69795 Views
- NetCore, Patni, SAP Labs, Temenos, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ravindra singh
select b.marks from (select distinct marks from student)
a,(select distinct marks from student) b
where a.marks >= b.marks
group by b.marks
having count(b.marks)=3
| Is This Answer Correct ? | 9 Yes | 7 No |
Post New Answer View All Answers
What is sql server 2000 work load governor?
Do you know what is similarity and difference between truncate and delete in sql?
How to optimize stored procedures in sql server?
What are indexers?
what are the Prerequisites for Replication?
What is the difference between truncate and delete commands?
What is an sql server agent?
What is the maximum size of a dimension? : sql server analysis services, ssas
How you can find out if an index is useful to the optimizer?
Explain trigger and trigger types?
What is the maximum rows in sql server table?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
Explain forward - only cursors?
What is view in sql?
what data regions are and what are the different data regions?
