This doesn't seem to be making sure that the "newest" commentid is the result... Seems to be random.
Your requirements are unclear.
If you want output sorted by descending order of commentid, then your original query should produce that. In that case, however, the GROUP BY seems irrelevant.
Given that you've included a GROUP BY, it appears that what you may want is output grouped by commentref, with rows for a given commentref value sorted by descending commentid value. In that case, the query suggested by Dan appears to me to be what you want.
Yet you state that neither query produces the correct result.
Perhaps you could clarify what you want. Please show a sample result, indicate why it is not correct, and indicate what the correct result would look like.
You might also indicate what "most active" in your original description has to do with the problem to be solved. There is nothing in your table structure that appears to relate to assessment of "activity".
At 09:11 AM 10/6/2003 -0400, you wrote:try
select commentid, commentref from comments ORDER by commentref ,commentid DESC;
> but any thoughts?-----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 -
-- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
