write a query to get maximum salary from the employers table
without duplicates....kindly help me
- 5 Answers
- 9212 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 |
I have a flat file, want to reverse the contents of the flat file
what are testing in a mapping level please give brif eplanation
how we load the data from source to staging area
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Why union transformation is an active transformation?
I have a source file its is CSV(comma separated). I want to convert it to tab separated. Make sure the conversion happens on all commas except the ones enclosed in Double quotes .
What is a filter transformation and why it is an active one?
what is mystery dimension?
Please create a mapping where I have source which has one column with name like Aman_Gupta Rakesh_Mehra Sachin_More I want the target field should contain the name in reverse order i.e Gupta_Aman Mehra_Rakesh More_Sachin. Can you please tell me what transformation would be needed to do this.
What are the types of error logs available in Informatica?
What is the role of informatica in project ?Like i showed financial projects?
Teradata 
