 <p>There was a post from @niktrs that provided the right answer, but it's been deleted! </p> <p>So, here's the query I was looking for, with @niktrs help. If his post comes back, I'll accept it.</p> <pre><code>SELECT new_wage FROM hr_wages WHERE effective_date IN (SELECT effective_date,new_wage FROM hr_wages WHERE employee_code='06031-BOB') AND employee_code='06031-BOB' </code></pre> <p>This ugliness can be beautified, I'm sure.</p>