display the latest status of user id
<p>I'm trying to display the latest users status but for some reason the output keeps displaying them all. </p>

<p>For example, this is my table</p>

<pre><code>employeeid | employee  | status
123        | Don Smith | 0
123        | Don Smith | 1
</code></pre>

<p>This is what I'm trying to get; the latest Don Smith Status</p>

<pre><code>employeeid | employee  | status
123        | Don Smith | 1


SELECT spe1.employeeid, spe1.employee, spe1.status 
FROM sp_employees spe1 
WHERE spe1.employeeid = (SELECT spe2.employeeid
                     FROM sp_employees spe2
                     WHERE spe1.employeeid = spe2.employeeid           
                     ORDER BY spe2.employeeid DESC
                     LIMIT 1)
</code></pre>