I'm trying to get a list of distinct values.
Lets say I have a list of ids.
1
2
3
4
Those ids have other info, specifically timestamps. So if I have multiple events on one of the id, then it gets another timestamp. So what I end up is something like this:
Id timestamp
1 3:04 pm
2 5:03 pm
2 5:05 pm
3 6:00 pm
3 6:30 pm
4 7:00 pm
So how would I go about doing a select distinct(id) where it only grabs the first one?
Lets say I have a list of ids.
1
2
3
4
Those ids have other info, specifically timestamps. So if I have multiple events on one of the id, then it gets another timestamp. So what I end up is something like this:
Id timestamp
1 3:04 pm
2 5:03 pm
2 5:05 pm
3 6:00 pm
3 6:30 pm
4 7:00 pm
So how would I go about doing a select distinct(id) where it only grabs the first one?