Can't retrieve correct data

Databases
1

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
FROM price_slot_cancels
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

2 
SELECT link_id 
     , MAX(`timestamp`) AS latest
  FROM price_slot_cancels
 WHERE `timestamp` &gt; '2012-06-16 00:00:00'
   AND `timestamp` &lt; '2012-06-30 00:00:00'
GROUP 
    BY link_id
ORDER 
    BY latest DESC

note TIMESTAMP is a reserved word – you really should rename that column

3

Thanks! Awesome! and I took your advice and renamed the column