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
- 4 Answers
- 8289 Views
- Bank Of America, I also Faced
- E-Mail Answers
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
How to call shell scripts from informatica?
How would you join a node to the already existing domain?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
Explain joiner transformation in informatica
How can one identify whether mapping is correct or not without connecting session?
What is the need for an etl tool?
Could you explain what is enterprise data warehouse?
What does refresh system mean, and what are its distinctive choice?
How to improve the performance of a session using sorter transformation?
Explain load alternative records / rows into multiple targets - informatica
Where can we find the throughput option in informatica?
Sequence generator, when you move from develoment to production how will you reset
tell me the rules and responsblites in our project(my project is development)
How you can differentiate between connected lookup and unconnected lookup?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
