delphi123 Posted December 11, 2007 Share Posted December 11, 2007 Hi, I've got a table that's listing loads of pieces of software. The key columns in the table are software_name, software_version & software_release_date. This is used to present a table listing like this: Microsoft Office 2003 - released 01/09/2002 Lotus Notes 10 - released 02/05/2004 Microsoft Office 2000 - released 01/08/1999 Microsoft Office 97 - released 02/06/96 Lotus Notes 9 - released 02/05/2002 Open Office 10 - released 09/04/2004 Open Office 9 - released 09/01/2001 Now what I need to do is show a table with the most recent version of each software, so the above list would return: Microsoft Office 2003 - released 01/09/2002 Lotus Notes 10 - released 02/05/2004 Open Office 10 - released 09/04/2004 Can anyone give me an idea how/if this can be achieved? Quote Link to comment Share on other sites More sharing options...
phpQuestioner Posted December 11, 2007 Share Posted December 11, 2007 order DESC by your date variable Quote Link to comment Share on other sites More sharing options...
delphi123 Posted December 11, 2007 Author Share Posted December 11, 2007 hmm yeah, that'll order by date (which I have already, but what i need is a way to ensure each piece of software only appears once (ie group them by the software name and pick the newest, then group the next software name and pick the newest etc...) Quote Link to comment Share on other sites More sharing options...
delphi123 Posted December 11, 2007 Author Share Posted December 11, 2007 arrgh! I'm playing with Group by, but I don't really know what I'm doing! Can anyone provide a few pointers for a dunce ??? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.