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 dynamic cache?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Explain sql transformation in script mode examples in informatica
Explain the aggregator transformation?
What are the limitations of joiner transformation?
What do you mean by enterprise data warehousing?
How to load last n records of file into target table - informatica
Quickly characterize reusable change?
Have you worked with/created Parameter file
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is a sorter transformation?
What is the benefit of partitioning a session?
What is a stored procedure transformation?
What does role playing dimension mean?