write a query to get maximum salary from the employers table
without duplicates....kindly help me

Answer Posted / rama

select (distinct max(sal)) from emp

Is This Answer Correct ?    16 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is expression transformation?

641


In informatics server which files are created during the session rums?

642


What is a stored procedure transformation?

614


What is workflow? What are the components of workflow manager?

716


What is decode in static cache?

600






Define sessions in informatica etl?

626


Why union transformation is an active transformation?

663


what is the complex transformation you used in informatica

2199


How do you load only null records into target?

746


Can we create a node as a gateway node and the same node can be assigned to a grid?

643


in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use

1661


What is the difference between a repository server and a powerhouse?

824


How to join three sources using joiner? Explain though mapping flow.

708


What are the conditions needed to improve the performance of informatica aggregator transformation?

587


Design a mapping to load a target table with the following values from the above source?

889