sql - How do I limit the amount of results returned in Sybase? -


I need to query a Sibez database in which it contains a lot of data, and want to set a threshold so that DB Stops the query after 10 results.

Important thing is performance, so it will be used after the search of all the results and then will return the last 10 results.

Thanks

I believe you must first SET ROWCOUNT 10, , all questions will not return any more than 10 rows in this session until further any SET ROWCOUNT , as a comment, in this session, Em> all does not close the following questions (only SELECT s!) (Set to 0) or set aside - this "global" effect, the specific LIMIT makes it easier than a section Land, which naturally is a per-query, but I do not think you can do anything about it.


Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

Which Python client library should I use for CouchdB? -