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
- 68491 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 public role in sql server?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
What is role playing dimension with two examples? : sql server analysis services, ssas
What is buffer cash and log cache in sql server?
What do you understand by the data quality services in sql server?
What are policy management terms?
How to start and end transact-sql statements?
Does the unique constraint create an index?
How to disable a login name in ms sql server?
How to choose all records from the table?
what is a correlated sub-query? : Sql server database administration
How do you identify a foreign key?
Tell me what are cursors and when they are useful?
Explain hostprotectionattribute in sql server 2005?
