title: How to remove duplicate records in grid?
body: <p>Good morning !</p>
  
  <p>What is the best way to remove duplicate records from grid control?  I use Delphi 2009 and devEx quantumGrid component.</p>
  
  <p>I tried looping through all the records and when a duplicate record is found then add it to list and apply filter on grid.  I found this as time consuming logic.  There are also two downsides of this approach.</p>
  
  <p>[1]  When the duplicate records are considerably more say 10K records then applying filter takes lot of time, because of lot of entries to filter out.</p>
  
  <p>[2] Looping through all the records is itself time consuming for big result set like 1M rows.</p>
  
  <p>SQL query returns me distinct rows, but when the user hides any column in grid, then it resembles as if there are duplicate records(internally they are distinct).</p>
  
  <p>Is there any other way of doing this?</p>
  
  <p>Any ideas on this are greatly helpful !</p>
  
  <p>Thanks &amp; Regards,
  Pavan.</p>