title: Select top 2 rows for each product in sql access
body: <p>I have this query below. For each product, I'd want the top 2 rows that have the highest <strong>Note</strong>.
  <img src="https://i.stack.imgur.com/LDEYp.png" alt="Query" />
  So for example, for the product 177-R3A-K1-C, it would show only the row with the note 0,837 and the one with the note 0,741.</p>
  <p>This is my query code :</p>
  <pre><code>SELECT [Lot-Prix-Delai Requête].P_Code, [Lot-Prix-Delai Requête].F_Code, [Lot-Prix-Delai Requête].L_PrixUnitaire, [Lot-Prix-Delai Requête].L_Delais, [Lot-Prix-Delai Requête].L_Taille, [Lot-Prix-Delai Requête].M_Code, [Lot-Prix-Delai Requête].L_Code, Fournisseur.F_Flexibilite, Fournisseur.F_Fiabilite, Fournisseur.F_Collaboration, [F_Flexibilite]*0.058+[F_Fiabilite]*0.129+[F_Collaboration]*0.038 AS [Note]
  FROM Fournisseur INNER JOIN
       [Lot-Prix-Delai Requête]
       ON Fournisseur.[F_Code] = [Lot-Prix-Delai Requête].[F_Code]
  ORDER BY [F_Flexibilite]*0.058+[F_Fiabilite]*0.129+[F_Collaboration]*0.038 DESC;
  </code></pre>