title: What is the Equivalent syntax of mysql " LIMIT " clause in SQL Server
body: <p>What is the Equivalent syntax of MySQL " LIMIT " clause in SQL Server . I would like to use it for  doing paging of my results. (want to show records5 to 10 )</p>