Interested to Buy Any Domain ? << Click Here >> for more details...
empno sal
1 8000
2 9000
3 8000
4 1000 how to get highest sal wise rankings in rank t/r.
- 3 Answers
- 6525 Views
- I also Faced
- E-Mail Answers
Answer Posted / ganesh
write a query like
select * from <table_name> order by where sal=(select max(sal) from <table_name>)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
explain one complex mapping with logic? sales project?
What are the differences between joiner transformation and source qualifier transformation?
How we can create indexes after completing the loan process?
Explain why we use partitioning the session in informatica?
How to create the source and target database connections in server manager?
Describe an informatica powercenter?
Explain sql transformation in script mode examples in informatica
How can we delete duplicate rows from flat files?
Global and Local shortcuts. Advantages.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is the way to execute pl/sql script using informatica mapping?
Enlist the various types of transformations.
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What is the difference between a repository server and a powerhouse?
