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

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.

The key thing is performance, so it would be no use if it searched all results and then then returned the last 10 results.

Thanks in advance

Solution

I believe you can do a SET ROWCOUNT 10 first, then all queries in this session until a further SET ROWCOUNT will return no more than 10 rows. As a comment points out, this affects all following queries in the session (not just SELECTs!) until turned off (by setting to 0) or set differently -- this "global" effect makes it less handy than the typical LIMIT clause of other engines, which is inherently per-query, but, I don't think you can do anything about that.

How to properly delete data from a table and chain the deletion
Find procedure name in all other procedures
SQL-How to Insert Row Without Auto incrementing a ID Column?
Why can't I use an alias in a DELETE statement?
How do I perform a GROUP BY on an aliased column in SQL Server?
Running multiple SQL-Statements with Python
Using rangeBetween considering months rather than days in PySpark
How to find databases which accessible to me in Sql server?
data return incorrect using left join with 2 tables
Repeat rows specified number of times in PostgreSQL
How to visualize database tables in postgresql using pgAdmin?
Odata override behaviour of orderby
Unable to open BCP host data-file
How to join parent object with nested array using OpenJson SQL
batch update a column using sql
Queries using LIKE wildcards in sql server
Conditional aggregation in SQL: display condition-dependent count in percentage?
Parsing JSON with Oracle SQL without knowing incoming field names
In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
Convert SQL containing GROUP BY and SUM() to active record in CodeIgniter
output sql data to html with hyperlink
Update all column names to be lowercase
SQL Server pivoting on data without an aggregate
Flagging a row in new column based on conditions on previous and current rows
replace or remove characters and then cast to decimal
Export specific rows from a PostgreSQL table as INSERT SQL script
Query to get only numbers from a string
SQL grouping result to half hour
table is specified twice both as a target for INSERT and as separate source of data
SQL to JSON Need Bracket for Array that can have multiple rows