title: Select row each time value changes based on date order
body: <p>Good Day Hopefully I can explain my problem well enough.  I do not have any sample query as I can not get anything to work.  But my problem is I have a table that contains a list of accounts and their status and a date that a change occurred on the account.  I need to pull the account number and each time the status changes along with the first date it changed.  I have tried using rank and min(date) and max(date); the problem I am running into is the account can go back and forth between statuses and I need each time it changes. Also, a new row could be in the table with the same account number and status but the update date is different.</p>
  <p>This is sample data:</p>
  <pre><code>abc C50 1/20/2022
  abc C50 1/21/2022
  abc C09 2/20/2022
  abc C50 3/1/2022
  def A54 1/20/2022
  def A26 1/21/2022
  def A26 2/20/2022
  def A54 3/1/2022
  </code></pre>
  <p>As you can see account abc has 3 instances of C50 and one instance of C09 for my results I would expect to see, the earliest of the first two C50s, then the C09 and then next C50, since its a new status change.</p>
  <pre><code>abc C50 1/20/2022
  abc C09 2/20/2022
  abc C50 3/1/2022
  </code></pre>
  <p>For the second account def; I would expect to see the first A54, the first A26, then the next A54 on the 1st as it is a new instance.</p>
  <pre><code>def A54 1/20/2022
  def A26 1/21/2022
  def A54 3/1/2022
  </code></pre>