write a query to get maximum salary from the employers table
without duplicates....kindly help me
Answer Posted / deva
select (distinct max(sal)) from emp
group by sal.
When ever you use goupfunctions in select statement grup by clause is must.....other wise it will throw an error
Is This Answer Correct ? | 8 Yes | 13 No |
Post New Answer View All Answers
What is Session and Batches?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain the types of lookup transformation?
What is powercenter on grid?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
What is the function of look up transformation?
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.
What is difference between a gateway node and worker node?
How to load last n records of file into target table - informatica
What are the measure objects?
What are the guidelines to be followed while using union transformation?
Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?
what is the Default Source Option For Update Strategy Transformation?
How might you approve all mappings in the archive all the while?
What is transformation?