Re: Listing threads by newest posts?
Posted by:
Rick James
Date: February 28, 2009 05:47PM
I would say that Peter's lack of detail mocks Kyle's lack of detail. We need to see the schema you have and understand the distinction between a thread-id and a post-id. It will possibly require nested SELECTs and/or the GROUP BY trick to fetch the first (newest post, in your case) of each group.
Subject
Written By
Posted
February 27, 2009 12:19AM
February 27, 2009 01:23AM
Re: Listing threads by newest posts?
February 28, 2009 05:47PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.