Select unique data

[Paweł Matyja]

Hi everyone.

I have query like that:

"SELECT calldate as DATE_i_TIME, src as NUM, duration as TIME_wait FROM cdr WHERE calldate > now() - interval 100 hour AND dcontext LIKE "ext-queues" AND disposition LIKE "NO ANSWER" AND lastapp like "Queue" and Userfield <> "1" and outbound_cnum = """

This query gives me data:

2023-02-02 13:53:23 [phone]
2023-02-02 13:54:14 [phone]
2023-02-02 13:54:15 [phone]
2023-02-03 14:25:36 500478000 5
2023-02-03 14:25:36 500478000 5
2023-02-03 14:50:36 500478000 5
2023-02-03 14:50:36 500478000 5
2023-02-03 16:28:37 609945000 2
2023-02-03 16:33:26 [phone]
2023-02-03 16:48:53 609945000 2
2023-02-03 16:53:24 609945000 2
2023-02-03 17:03:52 [phone]
2023-02-03 17:10:32 [phone]
2023-02-03 17:23:17 609945000 2
2023-02-04 14:10:58 [phone]
2023-02-04 14:10:58 [phone]

How to modify query to get unique number (from third column)
Like that:

2023-02-02 13:54:15 [phone]
2023-02-03 14:50:36 500478000 5
2023-02-03 17:23:17 609945000 2
2023-02-04 14:10:58 [phone]

I'am not database programmer, I need this query for my project.
I will be grateful for your help :)