Interested to Buy Any Domain ? << Click Here >> for more details...
How to list Top 10 salary, without using Rank Transmission?
- 16 Answers
- 44043 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / chandu
select distinct a.sal from emp a where 10>=(select
count(distinct b.sal from emp b where a.sal<=b.sal)order by
a.sal desc
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Enlist the differences between database and data warehouse.
Why do we need informatica?
What are active and passive transformations?
What is primary and backup node?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
What is a transaction control transformation?
What is the reusable transformation?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What are data-driven sessions?
How you prepared reports for OLAP?
How to load the data from a flat file into the target where the source flat file name changes daily?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
Which files are created during the session rums by informatics server?
waht type of interface is used for testing the data in informatica
what is the difference between informatica6.1 and infomatica7.1
