Domanda di colloquio di PwC

How to retrieve unique rows from database

Risposte di colloquio

Anonimo

2 apr 2019

We can use group by or CTE for getting unique value

6

Anonimo

9 mag 2021

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

2