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

How to generate sequence numbers?

1029

How can you validate all mappings in the repository simultaneously?

1287

How to call shell scripts from informatica?

934

Briefly explain the aggregator transformation?

941

what is the Default Source Option For Update Strategy Transformation?

1166

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6039

What are the mapping parameters and mapping variables?

1087

can u any challenge your project?

1971

How we can create indexes after completing the loan process?

1142

What can we do to improve the performance of informatica aggregator transformation?

1041

What is meant by a domain?

1078

How to create the source and target database connections in server manager?

1034

What is the fact table?

993

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1031

How to partition the Session?

1040