title: sort and remove duplicate lines in a sql log
body: <p>I am trying to sort and remove duplicate lines in bash script. </p>
  
  <p>I have a sql log that outputs the sql statement and the execution time. I want remove lines that have the same sql statement and sort based on the execution time. Here are some samples lines</p>
  
  <blockquote>
  <pre><code>tid=0xa3f] Query Executed in 881.3504 ms; rowCount = 0; 
  indexesUsed(1):Foo_trade(Results: 0) "select distinct * from fooTable
  where  IN SET($1,$2) and jobSource = $3 order by jobId asc"
  
  tid=0xa3h] Query Executed in 881.3504 ms; rowCount = 0;
  indexesUsed(1):Foo_trade(Results: 0) "select distinct * from fooTable 
  where  IN SET($1,$2) and jobSource = $3 order by jobId asc"
  
  tid=0xb38] Query Executed in 138.22551 ms; rowCount = 0; 
  indexesUsed(1):Foo_Job(Results: 0) "select distinct * from 
  Foo_Job where state IN SET($1,$2) and jobSource = $3 order by jobId asc"
  </code></pre>
  </blockquote>
  
  <p>goal:
  to sort on same select statement to remove duplicates and then sort by execution time</p>