I just posted a question with a subject of "Revised optimization question"
and did some more searching and found the my problem should be titled
"group-wise maximum".
I need the group-wise maximum of this query based on payload_time:
CREATE PROCEDURE `getElement
Try looking at the documentation for "groupwise maximum".
http://dev.mysql.com/doc/refman/4.1/en/example-maximum-column-group-row.html
-Sheeri
On 5/5/06, Ian Klassen <[EMAIL PROTECTED]> wrote:
Hello,
I'm working on using a temporary table to get the group-wise maximum
Hello,
I'm working on using a temporary table to get the group-wise maximum for
a number of items. I have a table structure like:
CREATE TABLE item (
item_id int not null primary key,
name varchar(100) not null);
CREATE TABLE attribute_a (
index (item_id, time_id),
item_id int not
