From: Peter Brawley
Date: October 27 2010 6:39pm
Subject: Re: Selecting all minimum values
List-Archive: http://lists.mysql.com/mysql/223468
Message-Id: <4CC871C7.1040407@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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