PwC Interview Question

How to retrieve unique rows from database

Interview Answers

Anonymous

Apr 2, 2019

We can use group by or CTE for getting unique value

6

Anonymous

May 9, 2021

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

2