empno sal
1 8000
2 9000
3 8000
4 1000 how to get highest sal wise rankings in rank t/r.
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
What is resilience time?
What are the different transaction levels available in transaction control transformation?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Implementation methodology
hi real timers . iam waiting for ur reply regarding ETL TESTING
Explain incremental aggregation in informatica
can you please explain me pre session and post session options?
Differentiate between router and filter transformation?
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?
Explain the tuning lookup transformation - informatica
How can we improve session performance in aggregator transformation?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
tell me about your project functionality
Define update strategy?
What is sq transformation?