title: Creating a Wait List in SQL
body: <p>Let's Say, I have a Header Table with two Columns (Name and Date).</p>
  <pre><code>Paul | 10/12/2002  
  Donna | 07/11/2000  
  Gary | 03/14/2021
  </code></pre>
  <p>And I want to create a waitlist/que driven by oldest date first</p>
  <pre><code>Select * Order By Date
  </code></pre>
  <p>I can easily create a Next-Up style of que by sorting ASC or DESC on Date.</p>
  <p>But I need to go a step further.  I need to have my SELECT include a temporary column that shows what number, in the que, a person is.</p>
  <p>So - Gary logs in and sees that he is 3'rd in line, but only sees his information.</p>
  <p>Expected Results:</p>
  <pre><code>Name:  Gary     Date:  03/14/2021   Position:  3
  </code></pre>