PwC interview question

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

Interview Answers

Anonymous

Aug 4, 2020

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

1

Anonymous

May 26, 2018

One of the method is select a ROWID among duplicate columns