title: I want to sort each row in SQL, example is given below
body: <p>Input table:</p>
  
  <pre><code>first           second        ID
  vivek           singh         AB:CD
  dheeraj         kumar         CD:AB
  raj             sharma        AB:DF
  neha            singh         DF:AB
  shreya          shree         AB
  </code></pre>
  
  <p>Output table:</p>
  
  <pre><code>first           second        ID
  vivek           singh         AB:CD
  dheeraj         kumar         AB:CD
  raj             sharma        AB:DF
  neha            singh         AB:DF
  shreya          shree         AB
  </code></pre>
  
  <p>I want to sort on the values of <code>ID</code>, but I want <code>CD:AB</code> to be treated as equivalent to <code>AB:CD</code> and so forth.</p>