Results 1 to 3 of 3
Thread: Can't retrieve correct data
Jun 22, 2012, 20:59 #1
- Join Date
- Jan 2008
- 0 Post(s)
- 0 Thread(s)
Can't retrieve correct data
I am using two columns to select from. One is link_id and the other is timestamp. There are multiple entries of the same link and I want only the most recent posting each link in the list. I haven't been able to figure it out.
Here is what I have so far
SELECT DISTINCT `link_id` , `timestamp`
WHERE `timestamp` > ' 2012-06-16 00:00:00'
AND `timestamp` < '2012-06-30 00:00:00'
GROUP BY link_id
ORDER BY `timestamp` DESC
I've tried a bunch of different things and nothing is working
Thanks in advance
BungeeBones.com - A New Paradigm of Website Promotion