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
- 9835 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
What is a sorter transformation?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
What are the differences between a connected lookup and unconnected lookup?
can anyone explain me about retail domain project in informatica?
Difference between Data and Index Caches?
Write the unconnected lookup syntax and how to return more than one column.
How to generate or load values in to the target table based on a column value using informatica etl tool.
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the new features of informatica 9.x developer?
Can informatica load heterogeneous targets from heterogeneous sources?
How can we delete duplicate rows from flat files?
What is the status code in stored procedure transformation?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
