write a query to get maximum salary from the employers table
without duplicates....kindly help me
- 5 Answers
- 8868 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
MAX(SAL) will not give duplicate records in a single group
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
How many input parameters can exist in an unconnected lookup?
i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.
what is inline view?
how to send unique records to one target and duplicate records to another target by using dynamic lookup cache????? please explain me briefly///(when we use this we look up on which target unique target ya duplicate target)
Which transformation should we use to normalize the COBOL and relational sources?
4 Answers DELL, IBM, Lehman Brothers,
my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced
What are the basic needs to join two sources in a source qualifier?
How can one identify whether mapping is correct or not without connecting session?
What is a diff between joiner and lookup transformation
16 Answers CTS, Satyam, TCS, UHG,
What all are steps in up gradation of Informatica server?
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
why u go for dimensions ?
Teradata 
