title: SQL Select Distinct Top5 with Order By and Where
body: <p>I have a table where Employees can check assets and each of their checks is recorded in a table.</p>
  <p>Now I want to extract the 5 last checked Asset_Ids for a given employee. He might have checked the same asset more than once, each check is recorded in a table -EmployeeLog-</p>
  <p>Basically my table has 3 columns :</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Employee_ID</th>
  <th>DateChecked</th>
  <th>Asset_ID</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>06/10/2021  10:56:22</td>
  <td>1</td>
  </tr>
  <tr>
  <td>1</td>
  <td>06/10/2021  14:58:25</td>
  <td>1</td>
  </tr>
  <tr>
  <td>1</td>
  <td>02/10/2021  13:56:22</td>
  <td>2</td>
  </tr>
  <tr>
  <td>1</td>
  <td>06/10/2021  08:56:22</td>
  <td>1</td>
  </tr>
  <tr>
  <td>1</td>
  <td>04/10/2021  03:56:22</td>
  <td>1</td>
  </tr>
  <tr>
  <td>1</td>
  <td>06/10/2021  02:56:22</td>
  <td>3</td>
  </tr>
  <tr>
  <td>1</td>
  <td>06/10/2021  15:56:22</td>
  <td>2</td>
  </tr>
  <tr>
  <td>1</td>
  <td>03/10/2021  03:56:22</td>
  <td>5</td>
  </tr>
  <tr>
  <td>1</td>
  <td>06/10/2021  03:56:22</td>
  <td>5</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I have below query which lists Asset_IDs by check date, but I have to apply distinct and top 5 to this list which I couldn't, any help appreciated.</p>
  <pre><code>SELECT Asset_ID
  FROM EmployeeLog
  WHERE EmployeeID = @Emp_ID AND Asset_ID != '00000000-0000-0000-0000-000000000000'
  ORDER BY EmployeeLog.DateChecked Desc
  </code></pre>