write a query to get maximum salary from the employers table
without duplicates....kindly help me
- 5 Answers
- 8568 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / sudheer113
MAX(SAL) will not give duplicate records in a single group
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Why union transformation is an active transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is the benefit of partitioning a session?
What is the difference between writing a joiner query in ANSI style and THETA style?
Parameter and variable differences
Define filter transformation?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Different qualification between a related rotate toward the sky and isolates look upward?
what is SDLC way of code development?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How you prepared reports for OLAP?
How do you update the records with or without using update strategy?
What can we do to improve the performance of informatica aggregator transformation?
Does an informatica transformation support only aggregate expressions?
What are the various types of transformation?
