not works. it's still show same result. any idea?
----- Original Message -----
From: "Quentin Bennett"
<[EMAIL PROTECTED]>
To: "The Nice Spider" <[EMAIL PROTECTED]>;
<mysql@lists.mysql.com>
Sent: Thursday, August 10, 2006 12:43 PM
Subject: RE: Group by base on latest time field,
possible?
Try
select thread, subject, max(time)
from jos_sb_messages
group by thread
order by 3
-----Original Message-----
From: The Nice Spider
[mailto:[EMAIL PROTECTED]
Sent: Thursday, 10 August 2006 4:10 p.m.
To: mysql@lists.mysql.com
Subject: Group by base on latest time field,
possible?
I want the group by result take the latest field,
but
my query result look
like get the random row.
Here I described:
Thread Subject Time
-----------------------------------------
5 Re:test 3333333333 1155203794
5 test 3333333333 1155203772
8 test 444 1155203882
8 Re:test 444 1155203897
note: "time" field is INT(11) to store datetime in
integer value
QUERY
---------
select thread, subject, time
from jos_sb_messages
group by thread
order by time
RESULT
----------
5 Re:test 3333333333 1155203794
8 test 444 1155203882
What do I need is:
------------------
5 Re:test 3333333333 1155203794
8 Re:test 444 1155203897
I am using 3.23.58 for Windows.
How to get the result as I expected?
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam
protection around
http://mail.yahoo.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
The information contained in this email is
privileged and confidential and
intended for the addressee only. If you are not the
intended recipient,
you
are asked to respect that confidentiality and not
disclose, copy or make
use
of its contents. If received in error you are asked
to destroy this email
and contact the sender immediately. Your assistance
is appreciated.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
