PwC interview question

How to retrieve unique rows from database without using Distinct or Unique keyword

Interview Answers

Anonymous

4 Aug 2020

One method is to use GROUP BY the column(s) you want as distinct.

1

Anonymous

26 May 2018

One of the method is select a ROWID among duplicate columns