Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to display to 10 max record from the employee
table?
- 7 Answers
- 13721 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / madhoo
You are question is not clear.....you need decide based on
which column you want first 10 records.....
if you work on Salary column this is the query .......
select distinct sal from emp a
where (select count(*) from emp b where a.sal<b.sal)<=10
order by sal desc
/
Any queries on Sql please feel free to ask me i am very
interest in it......
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What do you mean by drill through report?
Explain what is the difference between microstrategy and cognos reporting tool?
How can I test reports in cagonos?
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
Can you define metrics designer?
----------------------What are the User Securities?
What is difference between informatica power mart and power center?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Explain is there any comparison available for cognos reportnet vs crystal reports?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
What condition do we use in Cognos when multiple path exits to reach the fact table.(i.e in BOXI we use CONTEXT when multiple path exit)
What is a Folder?
What is the difference between Open Connection command ang Open Session Command?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What is defined as catalog and types of catalogs in Cognos?
