title: QUALIFY-Like Function in SQL Server
body: <p>My table has 2 columns: <code>Emp_Name</code> and <code>Emp_NR</code>.</p>
  
  <p>It can happen that one <code>Emp_Name</code> value has 2 different <code>Emp_NR</code> values.</p>
  
  <p>I would like to create a <code>SELECT</code> statement that gets only a single value of <code>Emp_Name</code> and <code>Emp_NR</code></p>
  
  <p>The statement should be something like in Teradata:</p>
  
  <pre><code>SELECT 
      Emp_Name,
      Emp_NR
  FROM Table
  QUALIFY Row_Number OVER (PARTITION BY Emp_Name ORDER BY Emp__NR DESC) = 1
  </code></pre>
  
  <p>In addition to that, I would like to get the highest <code>Emp_NR</code> that is assigned to a specific <code>Emp_Name</code>.</p>