Here are the queries which illustrate Shawn's point. Now to sleep.
-- wrong
DROP TABLE IF EXISTS o1;
CREATE TABLE o1
SELECT customerid,shipcity,MAX(shippeddate) AS latest
FROM orders
GROUP BY customerid;
-- right
DROP TABLE IF EXISTS o2;
CREATE TABLE o2
SELECT DISTINCT o1.customerid,o1.shipc
LOL, three late nights in a row, lose that last post o' mine.
PB
-
Shawn Green wrote:
--- Peter Brawley <[EMAIL PROTECTED]> wrote:
Brian
Hi,
I hope this is the right list for this question. If not, I'm happy
to get help on where to post this question. Apo
Shawn,
Yep that's the theory, but where (i) the aggregate result is a column
value, rather than a sum or average for example, and (ii) id is unique,
I
have not been able to get MySQL to give a wrong
value with that approach, eg try the following with the northwind
database (it ought to be doa
--- Peter Brawley <[EMAIL PROTECTED]> wrote:
> Brian
> > Hi,
> >
> > I hope this is the right list for this question. If not, I'm happy
> > to get help on where to post this question. Apologies in advance
> if
> > this is an old question.
> >
> > We are designing a simple a tracking database w
Brian
Hi,
I hope this is the right list for this question. If not, I'm happy
to get help on where to post this question. Apologies in advance if
this is an old question.
We are designing a simple a tracking database with a table of entries
showing the current location of each it
On 4/27/06, Brian J. Matt <[EMAIL PROTECTED]> wrote:
> As the items move new time stamped entries are added to the
> database. How would you query to find the current location of all
> the items currently in the system. As you might expect we don't want
> to replace the entry for an item when a l
Invert the problem ;-)
Sort descending by the time_stamp field and limit the result to 1, i.e.
SELECT * FROM table_xyz ORDER BY time_stamp DESC LIMIT 1
Tim
-Original Message-
From: Brian J. Matt [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 27, 2006 1:37 PM
To: mysql@lists.mysql.co
