There is a redundant data in a database having two records of same person with same name. Write an SQL query so that the redundant data is removed and only one record of the person is available.
Sigiloso
select personname from tablename group by personname