<div>
<div class="content wysiwyg-content">
I have a table that has two fields: username and entrydate. I am trying to figure out the query to pull the latest combination of the two or most recent combination based upon the entrydate.<br />
<br />
So for example:<br />
<br />
user1, 01_May_2013<br />
user1, 29_May_2013<br />
user2, 01_April_2013<br />
<br />
The SQL I am looking to run should pull:<br />
<br />
user1, 29_May_2013<br />
user2, 01_April_2013<br />
<br />
Since I only want the most recent record in my pull I would only get the unique values and the most recent entry for user1.
</div>
</div>


I have a table that has two fields: username and entrydate. I am trying to figure out the query to pull the latest combination of the two or most recent combination based upon the entrydate.

So for example:

user1, 01_May_2013
user1, 29_May_2013
user2, 01_April_2013

The SQL I am looking to run should pull:

user1, 29_May_2013
user2, 01_April_2013

Since I only want the most recent record in my pull I would only get the unique values and the most recent entry for user1.

Oracle DB Syntax for Unique Records

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.