showing X fields from X total

From: Marcos <marcos(at)second(dot)ival(dot)es>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: showing X fields from X total
Date: 2001-01-23 18:27:33
Message-ID: 3A6DCD15.ECFE39F0@second.ival.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2001-01-23 18:35:29 VACUUM ANALYZE FAILS on 7.0.3
Previous Message Gunnar R|nning 2001-01-23 18:07:28 Re: Looking for info on Solaris 7 (SPARC) specific considerations