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

Explain the difference between a data warehouse and a data mart?

1018

What are the tuning techniques you applied during your last project

1980

Can we override a native sql query within informatica?

993

Why update strategy and union transformations are active?

998

Enlist the various types of transformations.

967

Briefly explain the aggregator transformation?

949

How to differentiate between the active and passive transformations?

1094

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

1019

Explain sessions?

996

What happens to map if we alter the datatypes between source and its corresponding source qualifier?

1003

What are the various types of transformation?

1111

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5703

What happens when a session fails and you click on recover?

1083

without table how to come first record only in oracle?

2214

Describe an informatica powercenter?

1050