title: Removing Duplicate Records from table based on a column
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/14183706/removing-duplicate-row-from-a-table-based-on-one-column">Removing Duplicate row from a table based on one column</a>  </p>
  </blockquote>
  
  
  
  <p>I created a table with multiple inner joins from 4 tables but the results brings back duplicate records. Here is code that I am using</p>
  
  <pre><code>  DataSet quotetobepostedlist = DataRepository.Provider.ExecuteDataSet(System.Data.CommandType.Text,
        "Select  tblLoadStop.LoadID
             , tblCustomer.CustomerID
             ,tblLoadMaster.Salesperson
             ,OriginationState
             , DestinationState
             ,LoadRate
        FROM tblLoadMaster 
        INNER JOIN tblLoadSpecifications ON tblLoadSpecifications.LoadID=tblLoadMaster.LoadID  
        INNER JOIN  tblLoadStop ON tblLoadStop.LoadID=tblLoadMaster.LoadID 
        INNER JOIN tblStopLocation ON tblStopLocation.StopLocationID=tblLoadStop.StopLocationID  
        INNER JOIN tblCustomer ON tblCustomer.CustomerID =tblLoadMaster.CustomerID 
        WHERE tblLoadMaster.Phase LIKE '%2%' 
        ORDER BY tblLoadMaster.LoadID DESC;");
  </code></pre>
  
  <p>This is the result that I get</p>
  
  <pre><code>Load ID   Customer   Salesperson     Origin  Destination     Rate    
  13356     FedEx           Alex           Duluth    New York     300
  13356     FedEx           Steve          Florida   Kansas       400
  </code></pre>
  
  <p>I only want the first row to show, </p>
  
  <pre><code>13356     FedEx           Alex           Duluth    New York     300
  </code></pre>
  
  <p>and remove the bottom row,</p>
  
  <pre><code>13356     FedEx           Steve          Florida   Kansas       400
  </code></pre>