showing X fields from X total

hi,
i have posgresql 6.4 and jdbc6.4.
i am making a query returning like 6000 registers. I would like to
restrict the query in order to show the result 100 by 100 registers.
how can i make that SQL query?

if i make " select * from files order by (name)";

thanks in advance,

marcos

--
m a r c o s @ i v a l . e s