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