SQL - select most recent employee information, based on Date
<p>I am trying to execute a simple code, which looks like what is shown below. </p>

<pre><code>SELECT MR.ID_NUMBER
, MR.LAST_NAME
, MR.FIRST_NAME
, MR.EMAIL_ADDRESS
, MR.ASSIGNMENT_STATUS
, MR.assignment_start_Date
, AD.Address_line1
, AD.Town_Or_City



FROM Master_Rv MR
, Address_Details_v AD


WHERE Last_Name = 'Test'
and AD.Person_ID = MR.PERSON_ID
</code></pre>

<p>When I run this code, Multiple rows of data are produced. I only want to retrieve the data with the most recent 'Assignment_Start_Date' if that is possible? I hope that makes sense.</p>

<p>I have done my research, but can not seem to get my head around it, hence why I have asked here. Thanks a lot in advance.</p>