select distinc postgres, delete double data postgres, data hapus tinggalin satu

http://www.vertabelo.com/blog/technical-articles/postgresql-select-distinct-on

http://www.postgresqltutorial.com/postgresql-select-distinct/




delete double data postgres


http://www.postgresonline.com/journal/archives/22-Deleting-Duplicate-Records-in-a-Table.html

https://www.postgresql.org/message-id/37013500.DFF0A64A@manhattanproject.com

http://rhnh.net/2011/04/30/deleting-duplicate-data-with-postgresql


cool hapus doble data tinggalin satu

http://stackoverflow.com/questions/6583916/delete-completely-duplicate-rows-in-postgresql-and-keep-only-1



ex :
select nrk,count(nrk) as jumlah
from gospay.gp_personal
where active = 'Y'
group by nrk
having count(nrk) > 1

Tweet