CODEWITHSUNDEEP
sqlpresto
Gaurav Bansal
Gaurav Bansal

Reputation: 5660

How to deduplicate in Presto SQL without with only varchar data

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?

Upvotes: 0

Views: 1086

Answers (1)

dfundako
dfundako

Reputation: 8324

Use DISTINCT?

SELECT DISTINCT id, activity, type
FROM your_table

https://prestodb.github.io/docs/current/sql/select.html

Upvotes: 3

Related Questions