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
8922 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 are the components of Informatica? And what is the purpose of each?

1055

Briefly define reusable transformation?

1131

What is the function of look up transformation?

1123

What is domain in terms of informatica?

1007

What is DR strategy for Informatica project?

1190

What is data movement mode in Informatica and difference between them?

1138

How can we create index after completion of load process?

1125

How can we update a record in the target table without using update strategy?

1150

Difference between Data and Index Caches?

1138

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1012

What is event and what are the tasks related to it?

1122

Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM

4160

how tokens will generate?

2204

where to store informatica rejected data? How to extract the informatica rejected data?

1007

Explain the features of connected and unconnected lookup.

935