duplicate records

[oracle_corrgi]

hi
how can i select duplicate records from view with rowid
thanxs

[MMcCarthy]

hi
how can i select duplicate records from view with rowid
thanxs

Try this ...

SELECT * 
FROM ViewName
Having Count(*) > 1;
 

[sendtosanju]

Hi,

You can not use rowid with view. Because view is a virtual/logical thing. It does not contain any physical data. rowid is a physical address for row of the table. So you can not select duplicate rows from view with rowid.

Other alternative for that.

select col1,col2,col3,count(1) from table1 group by
col1,col2,col3 having count(1) > 1

[rahuljain]

Hi,

You can not use rowid with view. Because view is a virtual/logical thing. It does not contain any physical data. rowid is a physical address for row of the table. So you can not select duplicate rows from view with rowid.

Other alternative for that.

select col1,col2,col3,count(1) from table1 group by
col1,col2,col3 having count(1) > 1

can u explain that more clearly for me!!