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
- 68720 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 are key, name and value columns of an attribute? : sql server analysis services, ssas
What does it mean to manipulate data?
How to list all login names on the ms sql server?
What are constraints?
Explain what stored procedure sp_replcounters is used for? : sql server replication
What is the optimization being performed in oracle and SQL Server?
What do you mean by stored techniques? How would we use it?
Why use cursor in sql server?
What is the difference between a clustered index and a non-clustered index?
Define inner join? Explain with an example?
What is role playing dimension with two examples? : sql server analysis services, ssas
Can you explain different types of locks in sql server?
What is user-defined scalar function?
How to convert numeric values to integers in ms sql server?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
