Interested to Buy Any Domain ? << Click Here >> for more details...
write a sql query following table some duplicate present
1
1
2
2
3
3
4
5
i want the output unique one column duplicate another
column following format like
unique duplicate
1 1
2 2
3 3
4
5
- 2 Answers
- 6099 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / babu
Hi,
SELECT DISTINCT(DEPTNO) UNIQ,E.DUP FROM EMP
LEFT OUTER JOIN
(SELECT DEPTNO DUP FROM EMP GROUP BY DEPTNO HAVING COUNT
(DEPTNO)>1) E
ON (EMP.DEPTNO=E.DUP)
please correct me if any thing wrong.
Thanks,
Babu
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
difference between informatica 8.1.1 and 8.6
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
What is fact table? Explain the different kinds of facts.
list out all the transformations which use cache?
What is sequence generator transformation in informatica?
How we can create indexes after completing the loan process?
can we override a native sql query within informatica? Where do we do it?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How many transformations can be used in mapplets.
Write the program through which the records can be updated?
What is a passive transformation?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
Explain sessions?
