Pergunta de entrevista da empresa PwC

How to retrieve unique rows from database

Respostas da entrevista

Sigiloso

2 de abr. de 2019

We can use group by or CTE for getting unique value

6

Sigiloso

9 de mai. de 2021

Select your_column,count(*) from your_table Group by your_column Having count(*)>1;

2