What is the Sybase syntax of mySQL's LIMIT??
I've looked through the manual and it doesn't appear that there is one. If I can't find one I may just store the whole select statement into an array and then when i pull the data out with while statements I'll just use a count and that way i can display the records I want. But that sure does seem like it would be time consuming if there are 20,000 records or so. Thought?
Microsoft SQL is as follows
SELECT TOP x n,... FROM table
Not sure if sybase has this though
IIRC in Sybase it's something like
SET ROWCOUNT=10 go SELECT ...... go
SET ROWCOUNT is for sybase what LIMIT does for mySQL. I might be wrong, just popped out of my head
