title: Select a record with most recent date and time in Oracle
body: <p>I have a question regarding a SQl query in Oracle where IO need to select rthe row with the most recent date and time where date and time are inserted into two separate columns.</p>
  
  <p>Table <code>TransactionRecords</code></p>
  
  <pre><code> CustomerID    TransactionDate   TransactionTime
  -------------------------------------------------------
    0206016         17-APR-17         15:29:34
    0213570         17-APR-17         15:29:32
    0211384         17-APR-17         13:29:34
    0487674         16-APR-17         14:29:30
    0487759         15-APR-17         13:29:32
    0487213         12-APR-17         13:29:32
    0191022         11-APR-17         15:29:33
    1141158         29-OCT-16         01:25:51
  </code></pre>
  
  <p>I am expecting my query to rerturn the most recent transaction which should be :</p>
  
  <pre><code>   CustomerID    TransactionDate   TransactionTime
    ---------------------------------------------------
      0206016        17-APR-17            15:29:34
  </code></pre>
  
  <p>When I am running the following query :</p>
  
  <pre><code> select * from TransactionRecords tst
   where tst.TransactionDate  in (select max(TransactionDate) from 
   TransactionRecords)
  </code></pre>
  
  <p>I am getting all the transactions that happened on the most recent date.
  Can someone please give me any suggestions?</p>