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
- 67308 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 to get a list of all tables with "sys.tables" view in ms sql server?
What is the maximum size of a row in sql server?
What methods do you follow to protect from sql injection attack?
How does index makes search faster?
What is meant by dirty read?
What are various limitations of the views?
Difference between primary key and clustered index?
What is the importance of three tier architecture?
How to manipulate data from one table to another table ?
mention different types of relationships in the dbms?
Why do we use non clustered index?
What are diverse clauses that form a part of sql?
What is repeatable read?
Can we perform backup restore operation on tempdb?
What happens if you are trying to access a schema not owned by you?
