Re: How to select the last entry per item

--- 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 with a table of

Re: How to select the last entry per item

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 second_col value with that approach, eg try the following with the northwind database (it

Re: How to select the last entry per item

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.

Re: How to select the last entry per item

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

How to select the last entry per item

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 item in the system.

RE: How to select the last entry per item

@lists.mysql.com Subject: How to select the last entry per item 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

Re: How to select the last entry per item

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

Re: How to select the last entry per item

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