How to deduplicate in Presto SQL without with only varchar data

Question

My question is related to this one. However, I have only varchar data so I can't use the solutions there. My data looks like this:

id   | activity | type
------------------------
al12 |  a1a4    | MOVE
la23 |  2a5e    | WAIT
la23 |  2a5e    | WAIT
ie42 |  35a8    | STAY

The third row is a duplicate. How can I remove it?

score 3 · Accepted Answer · answered Jun 21 '19 at 17:35

3

Use DISTINCT?

SELECT DISTINCT id, activity, type
FROM your_table

answered Jun 21 '19 at 17:35

dfundako

1 Answers1