Messaging:- Need to find last child of its parent with in the same table
Because of my hard work I got the answer:-          

SELECT 
    parent.pkUserDiscussionID, 
    child.UserDiscussionMessage AS childmsg, 
    parent.UserDiscussionTitle, 
    parent.UserDiscussionMessage AS parentmsg 
FROM user_discussion parent 
LEFT JOIN user_discussion child 
    ON child.fkDiscussionParentID = parent.pkUserDiscussionID 
    AND child.pkUserDiscussionID = 
    (
        SELECT max( pkUserDiscussionID ) 
        FROM user_discussion AS c 
        WHERE c.fkDiscussionParentID = parent.pkUserDiscussionID 
    )
WHERE 
    parent.fkDiscussionParentID =0 
GROUP BY 
    parent.pkUserDiscussionID 
ORDER BY 
    parent.pkUserDiscussionID ASC 
LIMIT 0 , 30


Can anyone suggest anything better than this?