select count(*),col1,col2 ..... from table_name groupby col1,col2..... ha

write a query for how to eliminate the duplicate rows
without using distinct?

Question Posted / bharu_295

Answer Posted / bharu_295

select count(*),col1,col2 ..... from table_name
groupby col1,col2.....
having count(*)>1

Is This Answer Correct ?

2 Yes

9 No

Please Help Members By Posting Answers For Below Questions

without table how to come first record only in oracle?

2299

How do you migrate data from one environment to another?

1141

Explain the informatica workflow?

1122

How do you take back up of repository?

1206

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

2004

what are the deliverables?in your project?

2194

What is enterprise data warehousing?

1104

What is blocking transformation?

1185

how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2504

How can we use mapping variables in informatica? Where do we use them?

1280

What is the function of look up transformation?

1172

Explain why we use partitioning the session in informatica?

1161

How we can use union transformation?

1099

Why sorter is an active transformation?

1250

Where are the source flat files kept before running the session?

1137