unique select distinct name,id from table duplicate select name,i

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

Question Posted / anto

4 Answers
8774 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

Please Help Members By Posting Answers For Below Questions

Why do you use Mapping Parameter and mapping variable?

1701

What are the different transaction levels available in transaction control transformation?

1136

How to open an older version of an object in the workspace?

1150

What are the components of workflow manager?

1034

What is fact table? Explain the different kinds of facts.

1025

What does update strategy mean, and what are the different option of it?

1054

Explian the Process of deployment groups in informatica

1003

What do you mean by worklet?

1027

Define pmcmd command?

1000

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7339

Explain the aggregator transformation?

1104

What differs when we choose the sorted input for aggregator transformation?

981

draw informatica architecture 8.6 ?

3831

What is the need of etl tools?

1068

What is the format of informatica objects in a repository?

984