Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to get maximum salary from the employers table
without duplicates....kindly help me
- 5 Answers
- 10030 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / asdfg
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 ? | 0 Yes | 9 No |
Post New Answer View All Answers
What does cheating measurement mean?
How are indexes created after completing the load process?
How does the aggregator transformation handle null values?
what is the size of u r source(like file or table)?
What is option by which we can run all the sessions in a batch simultaneously?
What is pmcmd command?
As union transformation gives UNION ALL output, how you will get the UNION output?
What is a surrogate key?
Explain transaction control transformation in informatica
What are the different clients of powercenter?
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
What is informatica? Why do we need it?
What is the need for an etl tool?
Difference between Target-based loading and constraint-based loading?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
