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
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
How to use procedural logic inside infromatica?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Explain the difference between a data warehouse and a data mart?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
What is event and what are the tasks related to it?
What could be the possible resons of locks by user?
What all join we can perform in LOOKUP transformation?
What is a repository? And how to add it in an informatica client?
If informatica has its scheduler why using third party scheduler?
Suppose we do not group by on any ports of the aggregator what will be the output?
How do we call shell scripts from informatica?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
How you can differentiate between connected lookup and unconnected lookup?