write s sql query following table some duplicate present i
want unique one column duplicate another column display?
name id
a 1
a 1
b 2
b 2
c 3
i want the required output like
unique duplicate
name id name id
a 1 a 1
b 2 b 2
c 3
Answer Posted / anto
unique
select distinct name,id from table
duplicate
select name,id from table
group by name,id
having count(name||id) > 1
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Why do you use Mapping Parameter and mapping variable?
What are the different transaction levels available in transaction control transformation?
How to open an older version of an object in the workspace?
What are the components of workflow manager?
What is fact table? Explain the different kinds of facts.
What does update strategy mean, and what are the different option of it?
Explian the Process of deployment groups in informatica
What do you mean by worklet?
Define pmcmd command?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain the aggregator transformation?
What differs when we choose the sorted input for aggregator transformation?
draw informatica architecture 8.6 ?
What is the need of etl tools?
What is the format of informatica objects in a repository?