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
9070 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

What is the need of etl tools?

1180

WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

1962

Does an informatica transformation support only aggregate expressions?

1086

What are the components of workflow manager?

1153

How can a transformation be made reusable?

1229

What is Data Caches size?

1127

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2174

What are the different versions of informatica?

1332

Explain what are the different versions of informatica?

1144

What are session parameters ? How do you set them?

1899

what is the size of your data warehousing?

2141

What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?

1017

What are the static cache and dynamic cache in informatica?

1243

What is incremental aggregation?

1135

What is a surrogate key?

1153