----- Original Message -----
From: "Eric Anderson" <ke...@on-e.com>
To: <mysql@lists.mysql.com>
Sent: Tuesday, October 20, 2009 4:05 PM
Subject: Re: Distinct max() and separate unique value
I'm trying to formulate a query on a Wordpress database that will give
me the highest 'object_id' with the highest 'term_taxonomy_id',
something like:
+-------------------------+------------------+
| max(distinct object_id) | term_taxonomy_id |
+-------------------------+------------------+
| 1503 | 127 |
| 1494 | 122 |
+-------------------------+------------------+
But I just can't seem to get there?
I confess I did not understand what you are trying to do.
If what you actually want is the highest 'term_taxonomy_id' for each
distinct objhect_id then the query would be:
select object_id, max(term_taxonomy_id)
where term_taxonomy_id IN (122,127)group by object_id
order by object_id desc;
This query will not take into consideration term_taxonomy_Id values other
than 122 and 127, it also will not return object_id's without a
term_taxonomy_Id value of 122 or 127.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
