Hi,
how can i do to limit the number
of rows retrieved in a select statement?

For example in sybase there is "set rowcount" command.

Thank you.

"select * from table1 fetch first n rows"

Thanks for your reply.

Your code works perfectly.
But I want ask you another question:

I have a java web application that retrives a large amount of data that are display like lists and charts.
I want to know if there's a possibility of managing this data little by little
without load all in session.
Now my list loads the entire resultSet in session and display only
20 rows at time using back and forward utility, but the memory space grows too much.

Can you help me?
Thanks Stenx