Sollicitatievraag bij PwC

How to retrieve unique rows from database

Antwoorden op sollicitatievragen

Anoniem

2 apr 2019

We can use group by or CTE for getting unique value

6

Anoniem

9 mei 2021

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

2