title: What is the use of WITH TIES keyword in SELECT statement in SQL Queries?
body: <pre><code>SELECT TOP 5 WITH TIES EmpNumber,EmpName 
  FROM Employee 
  Order By EmpNumber DESC
  </code></pre>
  
  <p>This above query return more than five result, What is the use of "With Ties" keyword SQL Queries.</p>