Hi,
I am newbie to sybase. Can some one tell me Sybase equivalent functions for the following MYSQL functions

• limit
• found_rows
• SQL_CALC_FOUND_ROWS

limit: set rowcount X, where X is the number of rows you want the limit set to.
found rows: select @@rowcount. returns the number of rows affected in the last query.

I don't know what SQL_CALC_FOUND_ROWS does, so I can;t help you with that one.

thanks, martijnvs.

SQL_CALC_FOUND_ROWS does the following functionaliy :-

A SELECT statement may include a LIMIT clause to restrict the number of rows the server returns to the client. In some cases, it is desirable to know how many rows the statement would have returned without the LIMIT, but without running the statement again. To obtain this row count, include a SQL_CALC_FOUND_ROWS option in the SELECT statement, and then invoke FOUND_ROWS() afterward:

mysql> SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name
-> WHERE id > 100 LIMIT 10;
mysql> SELECT FOUND_ROWS();

The second SELECT returns a number indicating how many rows the first SELECT would have returned had it been written without the LIMIT clause.

In the absence of the SQL_CALC_FOUND_ROWS option in the most recent SELECT statement, FOUND_ROWS() returns the number of rows in the result set returned by that statement.


is there any way in sybase with same functionality what SQL_CALC_FOUND_ROWS do..

Hmm, I do not know of any function that does that.
Supposed you have this query: select id, name from mytable:
will give 200 records (limit)
will give 200 records, plus the number 200, for the 200 records returned.

If you want to know how many records would have returned without the set rowcount-command, you could use this one:
This one only returnes the number of rows of that query. It is calculated on the server, so it should save you some time (the time it would take to send the resultset and display it on your client).

Martijnvs, thank for the info..

but actually now i am doing porting. so i have to write a single query to limit the no of records. by using rowcount i have to send more than 1 query from my application. is there any smart way to do in a single query??

Why would you want to limit your resultset with something like 'limit'? If you want a specific, limited set of records, you can use a where-clause, but you can't specify an exact number of records as far as i know.

Can you post a sample of a query you want to port?

for the same reason that sybase developers use TOP

select day(servlet_start_time) as DayOfMonth
from
sla
group by
day(servlet_start_time)
order by
$orderby$
limit
$startRow$, $numRows$

this is the query ...i am using this query for pagination..i am planning to use pagination support by database

r937 , top is rocking but..if i want to get the rows from 15 to 20..like this..is there any some function..to do like this..i need this for paging

i would just return all 31 days

Dude, Google "Sybase LIMIT" or "SQL SERVER LIMIT" and you'll see exactly how to do the offset in T-SQL. That would've taken far less time than posting this thread.