I am new to Sybase. I would like to select only 100 rows from the Sybase using a single select statement.
I should involve something like a row count. I tried using the function number(*) it just returns the number but i couldn't use it to manipulate the values in the where condition.
Logically it should be like this "SELECT * FROM TABLE WHERE
ROW_NUMBER BETWEEN 50 AND 150" Dont mind the Syntax given in here.