write a query to get maximum salary from the employers table
without duplicates....kindly help me
- 5 Answers
- 8567 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
explain abt ur project architecture?
what are the deliverables?in your project?
How to load the data from people soft hrm to people soft erm using informatica?
What are mapplets?
What is aggregator transformation in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is joiner change?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What is Cognos script editor?
How are the sources and targets definitions imported in informatica designer?
How you prepared reports for OLAP?
Define update strategy?
What all are steps in up gradation of Informatica server?
Please let me know how to make encryption and decryption with example?
have u done any performance tuning? how u ll do?
