Обсуждение: Multiple occurence
Hi,
I have large table named duplicate_files (47GB) shown below. I need to find the multiple occurrence of the file_name with same size in each path.
I have large table named duplicate_files (47GB) shown below. I need to find the multiple occurrence of the file_name with same size in each path.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Regards,
Nipuna
nipuna wrote > select file_name,filesize, full_path from duplicate_files f1 where > > (file_name,filesize) in (select file_name,filesize from duplicate_files > group by file_name,filesize having count(file_name) >1); Maybe: Select file_name, filesize, array_agg(full_path) From duplicate_files Group by file_name, filesize Having count(*) > 1 You can always unnest the array later if needed. David J. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Multiple-occurence-tp5796336p5796345.html Sent from the PostgreSQL - novice mailing list archive at Nabble.com.