PwC Interview Question: How to retrieve unique rows from database | Glassdoor

Skip to content Skip to footer

Notifications

Loading...

employer cover photo

PwC

PwC SQL Developer interview

PwC interview question

SQL Developer Interview

How to retrieve unique rows from database

Interview Answers

Anonymous

2 Apr 2019

We can use group by or CTE for getting unique value

6

Anonymous

9 May 2021

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

2

Related searches: PwC reviews | PwC jobs | PwC salaries | PwC benefits | PwC conversations