 <p>TOP is the equivalent of LIMIT in sql server: <a href="http://www.w3schools.com/sql/sql_top.asp" rel="nofollow">http://www.w3schools.com/sql/sql_top.asp</a></p> <p>As has been pointed out below, TOP is not the equivalent realy. In fact you need to use OFFSET and FETCH to exactly match the LIMIT behaviour: <a href="https://msdn.microsoft.com/en-us/library/ms188385.aspx" rel="nofollow">https://msdn.microsoft.com/en-us/library/ms188385.aspx</a></p>