title: How to Select only one unique record from the Table using Distinct
body: <p>my table have several records which has the same MemberID. i want to result out only one record. </p>
  
  <pre><code>select DISTINCT(MemberID)  from AnnualFees;
  </code></pre>
  
  <p>then result will come. but i want to show the other column data also but when i do this </p>
  
  <pre><code>select DISTINCT(MemberID),StartingDate,ExpiryDate,Amount  from AnnualFees;
  </code></pre>
  
  <p>all the details including same MemberID data also displaying. </p>
  
  <p>can someone help me. </p>