Pergunta de entrevista da empresa Hansa Solutions

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.

Resposta da entrevista

Sigiloso

21 de dez. de 2017

select personname from tablename group by personname

11