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

What is a code page?

702

What do you mean by blocking transformation?

574

Define filter transformation?

614

Global and Local shortcuts. Advantages.

1456

What are the different components of powercenter?

572

What is a joiner transformation and why it is an active one?

568

How we can create indexes after completing the load process?

605

Briefly explain the aggregator transformation?

582

The question was on time stamp. what is the difference between HH and HH24 when to use when.

1544

What are data-driven sessions?

709

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

1690

How many ways are there to do 'remove duplicate records in informatica'?

574

What is a sequence generator transformation?

563

To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?

666

What is a repository? And how to add it in an informatica client?

640