title: SQL to select specific rows from a Teradata table
body: <p><img src="https://i.stack.imgur.com/9bgwD.jpg" alt="Table rows"></p>
  
  <p>I have a Teradata table with information about job runs. The attached image shows information stored in table.
  There are multiple entries for each job in a day. I am in the process of automating job status based on the start and end time. I want to pick start_time of job V1S0 and end_time of job V5S0 highlighted in red from this table(the job highlighted in yellow run in a single batch). Can someone share SQL to do this.</p>
  
  <p>Thanks  in advance</p>