title: Top N Query - SQL Server 2008
body: <p>How would i return Top N Queries from SQL Server. I know how it is done in Oracle</p>
  
  <p><code>SELECT Empno, Ename, Job, Mgr, Hiredate, Sal
     FROM
     (SELECT Empno, Ename, Job, Mgr, Hiredate, Sal
        FROM Emp
        ORDER BY NVL(Sal, 0) DESC)
     WHERE ROWNUM &lt; 6;</code></p>
  
  <p>But how is the same query written in SQL Server ?. I never worked on SQL Server. So any classic solution is appreciated.</p>
  
  <p>Thanks</p>