gmocamilotd
1/12/2018 - 9:30 PM

duplicados en visual foxpro

visual fox pro registros duplicados vfp

* 1er metodo

Set ENGINEBEHAVIOR 70
SELECT * FROM Acnpagos WHERE Acnpagos.c_nropag in (SELECT TOP 10 Acnpagos.c_nropag FROM Acnpagos ORDER BY Acnpagos.c_nropag GROUP BY Acnpagos.c_nropag HAVING COUNT(Acnpagos.c_nropag)>1)


LOCATE FOR Acnpagos.c_nropag='GA14030275'

* 2do metodo

SELECT Acnpagos.c_nropag, COUNT(*) FROM Acnpagos GROUP BY Acnpagos.c_nropag HAVING COUNT(*) > 1