How to list Top 10 salary, without using Rank Transmission?
Answer Posted / raka
SQL:
SELECT id, salary from <table name> where rownum <= 10
ORDER BY salary DESC;
| Is This Answer Correct ? | 17 Yes | 20 No |
Post New Answer View All Answers
What is the difference between informatics 7x and 8x and what is latest version?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Could you explain what is enterprise data warehouse?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to join three sources using joiner? Explain though mapping flow.
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 standalone command task?
What are Dimensional table?
How many dimensions are there in informatica?
What is the meaning of decode in informatica?
Design time, run time. If you don't create parameter what will happen
How can you differentiate between powercenter and power map?
What is the scenario which compels informatica server to reject files?
Is it possible to create multiple domains on a single Informatica server?
What is a difference between complete, stop and abort?