Is this what you mean? select query, date, min(place) from tbl group by query, date;
PB ----- On 10/27/2010 1:34 PM, Matt Horrocks wrote:
Hi, I have the following table. How can I select the lowest `place` for each `query` for each `date` (some queries appear twice as they have a different `fullurl`). Thanks for your help. Matt [code] +-------+---------------+--------------------------------+------------+ | place | query | fullurl | date | +-------+---------------+--------------------------------+------------+ | 2 | query 1 | http://yyy.co.uk/zzz.html | 1288051200 | | 2 | query 2 | http://yyy.co.uk/xxx.html | 1288051200 | | 1 | query 2 | http://yyy.co.uk/ | 1288051200 | | 5 | query 3 | http://yyy.co.uk/ | 1288051200 | | 3 | query 1 | http://yyy.co.uk/xxx.html | 1288051200 | | 3 | query 2 | http://yyy.co.uk/zzz.html | 1288051200 | | 1 | query 1 | http://yyy.co.uk/ | 1288051200 | | 2 | query 2 | http://yyy.co.uk/xxx.html | 1287964800 | | 3 | query 2 | http://yyy.co.uk/zzz.html | 1287964800 | | 1 | query 1 | http://yyy.co.uk/ | 1287964800 | | 2 | query 1 | http://yyy.co.uk/zzz.html | 1287964800 | | 3 | query 1 | http://yyy.co.uk/xxx.html | 1287964800 | | 5 | query 3 | http://yyy.co.uk/ | 1287964800 | | 1 | query 2 | http://yyy.co.uk/ | 1287964800 | | 1 | query 1 | http://yyy.co.uk/ | 1287878400 | | 2 | query 1 | http://yyy.co.uk/zzz.html | 1287878400 | | 3 | query 1 | http://yyy.co.uk/xxx.html | 1287878400 | | 5 | query 3 | http://yyy.co.uk/ | 1287878400 | | 1 | query 2 | http://yyy.co.uk/ | 1287878400 | | 2 | query 2 | http://yyy.co.uk/xxx.html | 1287878400 | | 3 | query 2 | http://yyy.co.uk/zzz.html | 1287878400 | [/code] So it returns this [code] | 1 | query 2 | http://yyy.co.uk/ | 1288051200 | | 5 | query 3 | http://yyy.co.uk/ | 1288051200 | | 1 | query 1 | http://yyy.co.uk/ | 1288051200 | | 1 | query 1 | http://yyy.co.uk/ | 1287964800 | | 5 | query 3 | http://yyy.co.uk/ | 1287964800 | | 1 | query 2 | http://yyy.co.uk/ | 1287964800 | | 1 | query 1 | http://yyy.co.uk/ | 1287878400 | | 5 | query 3 | http://yyy.co.uk/ | 1287878400 | | 1 | query 2 | http://yyy.co.uk/ | 1287878400 | [/code]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
