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

Answer Posted / anil kumar

select distinct max(sal) from table name

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention a few design and development best practices for informatica?

563


Write the unconnected lookup syntax and how to return more than one column.

599


EXL informatica Questions

938


in reporting we add some new objects,how we get the count of the newly added objects to the report

1753


What is informatica? Why do we need it?

643






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

1572


What is joiner transformation in informatica?

629


 Informatica Checkpoints

2857


Explain the different lookup methods used in informatica?

589


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

1741


I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

643


What is domain and gateway node?

700


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1563


Explain your project of banking domian.

1220


Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

742