I have student marks in a student table. I need second
highest mark .Then what will the query for this?
- 37 Answers
- 62834 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
How do database indexes work?
Can you explain what is sql server english query?
Explain differentiate between a having clause and a where clause?
How to find which stored procedure is currently running in sql server?
How to use clusters?
In what version of sql server were synonyms released?
Why the trigger fires multiple times in single login?
How to connect to SQL Azure Database by using sqlcmd?
What is raiseerror? What is raiseerror?
How to create a scrollable cursor with the scroll option?
How do I view a stored procedure in sql server query?
What is the difference between DataRow.Delete() and DataRow.Remove()?
What types of replication are supported in sql server?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
State the difference between union and union all?
