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]
>
