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
- 10069 Views
- CTS, I also Faced
- E-Mail Answers
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
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
differences between service based and product based?
What is joiner transformation?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
What do you mean by filter transformation?
What will be the approach?
What are session parameters ? How do you set them?
What is resilience time?
Explain load alternative records / rows into multiple targets - informatica
What is the need of etl tools?
Explain in detail scd type 2 through mapping.
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is expression transformation?
Explain the pipeline partition with real time example?
