pcsoft.us.windevCopyright 2026, PC SOFT20 Feb 2016 22:46:00 Z18 Feb 2016 01:12:00 ZHello All, Is there a way with a query to find records with duplicates. Something like if you have a filed name find all records with more then 1 that are the same. DW30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56549/read.awp20 Feb 2016 22:46:00 ZHello Allard, I don't think so, You would have to loop thru all the records in the db that way. to see if to had the same …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56549/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56549/read.awpFind Duplicates in a fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56544/read.awp20 Feb 2016 16:23:00 ZHi easily done in wlanguage if hreadseek(file, name, search on) then // do this to be certain that at least 1 item exists…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56544/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56544/read.awpFind Duplicates in a fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56530/read.awp20 Feb 2016 00:11:00 ZHello All, Thank you I used Al's you tube video link and got it to work in the query editor. SELECT COUNT(JOB_INFO.PO) AS …https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56530/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56530/read.awpFind Duplicates in a fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56496/read.awp18 Feb 2016 10:53:00 ZSELECT dup_field, count(*) FROM filename GROUP BY dup_field HAVING COUNT(*) > 1https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56496/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56496/read.awpFind Duplicates in a fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56483/read.awp18 Feb 2016 02:54:00 ZHi DW If all you want is to find the duplicate records something like the following works. SELECT * FROM LOCATION WHERE Locati…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56483/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56483/read.awpFind Duplicates in a fileguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56482/read.awp18 Feb 2016 01:50:00 ZHello DW If it is a one off request then WDMap can do easily, otherwise you will need to code a solution. I found this youtu…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56482/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/56476-find-duplicates-file-56482/read.awpFind Duplicates in a file