write a query like select * from <table_name> order by where sal=(

empno sal
1 8000
2 9000
3 8000
4 1000 how to get highest sal wise rankings in rank t/r.

Question Posted / ganesh

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

Please Help Members By Posting Answers For Below Questions

What are the validations that you can perform in oracle and in informatica ? Advance Thanks

2021

what is the Default Source Option For Update Strategy Transformation?

1166

how many types of dimensions are available in informatica?

997

How would you copy the content of one repository to another repository?

949

Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1024

Define joiner transformation?

986

EXL informatica Questions

1310

Write the different tools in the workflow manager?

994

What will be the approach?

929

How to load data in informatica ?

953

What are the issues you have faced in your project? How did you overcome those issues?

2289

What is complex mapping?

1068

if we have a delimiters at unwanted places in a flat file how can we over come those.

1985

Define filter transformation?

1031

Explian the Process of deployment groups in informatica

990