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
- 10238 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / asdfg
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 ? | 0 Yes | 9 No |
Post New Answer View All Answers
How to load a Dimension ? and how to load a fact table?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What is a pre-defined event and user-defined event?
How do you migrate data from one environment to another?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
How can informatica be used for an organization?
Enlist the tasks for which source qualifier transformation is used.
What is the commit type if you have a transaction control transformation in the mapping?
What are the informatica performance improvement tips
How to partition the Session?
What is domain and gateway node?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are different types of transformations available in informatica?
Explain informatica architecture - version 8 / 9
