title: How do I limit the amount of results returned in Sybase?
body: <p>I need to query a Sybase database which has a lot of data in it, and would like to set a limit so the DB stops the query after 10 results.</p>
  
  <p>The key thing is performance, so it would be no use if it searched all results and then then returned the last 10 results.</p>
  
  <p>Thanks in advance</p>