Hey all,
My Question:
1. I got a table which tracks errors on systems:
mysql select id, sys_id, beginn, end, status from error_t;
+++-+-+-+
| id | sys_id | begin | end | state |
- Original Message -
From: Chris Czeyka [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, February 20, 2003 10:02 AM
Subject: How to grab the latest record in one query?
[snip]
Either I'm stupid or it's impossible. Let's see which case is true. :)
I'm sure it's neither. :)
I
Hi,
I think that it's your GROUP BY clause that isn't correct.
Try replacing GROUP BY sys.name with GROUP BY error_t.sys_id
(ie, group using the same table where you applied the max() function)
I didn't tryed, hope it solves.
On Thu, 2003-02-20 at 15:02, Chris Czeyka wrote:
Hey all,
My