For instance;
mysql> select commentid, commentref from comments GROUP BY commentref ORDER by commentref DESC, commentid;
+-----------+------------+
| commentid | commentref |
+-----------+------------+
| 80 | 188 |
| 73 | 187 |
| 76 | 185 |
| 56 | 181 |
| 59 | 180 |
| 60 | 179 |
| 50 | 169 |
...
You can see for record 181 that "56" is the "highest" number after 181 is grouped. However this is not true;
mysql> select commentid, commentref from comments WHERE commentref=181; +-----------+------------+ | commentid | commentref | +-----------+------------+ | 56 | 181 | | 57 | 181 | | 79 | 181 | +-----------+------------+
You can see above that id(79)
At 09:11 AM 10/6/2003 -0400, Dan Greene wrote:
try
select commentid, commentref from comments ORDER by commentref ,commentid DESC;
> -----Original Message----- > From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 02, 2003 2:37 PM > To: [EMAIL PROTECTED] > Subject: sorting/grouping > > > > > I have a very simple table. > > commentid, commentref (each field is an INT) > > Each record is a comment... commentid is the ID (each new record is a > higher #).. and the commentref field if the "story" the > comment refers to. > > I want to be able to list the stories in order from "most > recent comment" > onward. > > I've tried > > select commentid, commentref from comments GROUP BY > commentref ORDER by > commentid DESC; > > However, the results are NOT showing me the stories in order > from most > active comments onward... Maybe too much soda and sugar - > but any thoughts? > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > >
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
Shawn Cummings Engineering Project Manager Global NAPs 10 Merrymount Rd Quincy, MA 02169 Desk 617-507-5150 VoIP 617-507-3550 [EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
