Simple SQL query.... maybe
I have a table..
Col1 username
Col2 installationname
Col3 issuedate
Col4 - Col10 various fields
I want a query to group by Col1 and Col2 and to return the whole record for the most recent date in Col3
I've tried various queries but although the grouping works the queries return the wrong record in the group.
Any suggestions
MikeW
Subject
Written By
Posted
Simple SQL query.... maybe
March 24, 2005 05:01AM
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.