title: How to get current transaction details for a user in SQL?
body: <p>ASSET_TRANSFER_TABLE</p>
  
  <pre><code> TRANSFER_ID  TRANSFER_DATE  ASSET_ID   STOCK_TAG  TRANSFER_FROM_ID  TRANSFER_TO_ID  
      111         dd/mm/yyyy      2122      222-222        Roy                Jina
  </code></pre>
  
  <p>Refering to the above table if a user has more than one asset in his/her account,the details for both the transaction has to be displayed.second,only the current transaction is to be displayed ie. previous trans where the same user used to hold an asset but it has been transferred to some other user,that the <strong>past transaction details should be omitted</strong>.</p>
  
  <pre><code>The result should display Transfer Id,Transfer Date,Asset ,Transfer to Id.
  </code></pre>
  
  <p>If anyone could help with this I would be really thankful.</p>
  
  <p>Thanks in advance.</p>