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

Explain the code page compatibility?

1046

What are the different types of olap? Give an example?

1027

write a query to retrieve the latest records from the table sorted by version(scd)

1047

lookup transformation with screenshots

3981

4 yrs etl devloper roles and responsibilities?any body give solutions

2147

how to create user defined function (udf) in informatica

1284

What are the data movement modes in informatica?

1130

What is the use of target designer?

1019

What are pre and post-session shell commands?

1277

what is the complex transformation you used in informatica

2573

Enlist the various types of transformations.

1018

What do you mean by blocking transformation?

1014

What is the need of etl tools?

1092

Please let me know how to make encryption and decryption with example?

1883

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

1062