MySQL Forums
Forum List  »  General

Advanced Search
New Topic

Re: GROUP BY and ORDER BY... why doesn't this work?
Posted by: hossein haghparast
Date: February 20, 2005 01:18PM

can you test following?
SELECT author, id, title, pub_date FROM postings ORDER BY pub_date DESC GROUP BY author ;

Hossein Haghparast, Ankara University Ph.D student in Economics
http://www.yeksite.com/

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
GROUP BY and ORDER BY... why doesn't this work?
Gabriel Gilder
February 20, 2005 01:12AM
Re: GROUP BY and ORDER BY... why doesn't this work?
hossein haghparast
February 20, 2005 01:18PM


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.