Path: utzoo!attcan!uunet!tut.cis.ohio-state.edu!ucbvax!agate!sunspot.berkeley.edu!ericco
From: ericco@ssl.berkeley.edu (Eric C. Olson)
Newsgroups: comp.databases
Subject: no. of rows
Message-ID: <ERICCO.90Oct27154113@sdaf1.ssl.berkeley.edu>
Date: 27 Oct 90 22:41:13 GMT
Sender: usenet@agate.berkeley.edu (USENET Administrator)
Distribution: comp
Organization: CEA @ UC Berkeley, Berkeley, CA, USA.
Lines: 14

I'm new to the SQL game, so bear with me.  Is there a way of
predicting the number of rows a query will return?  For example:

	select column1 from table1

Can I find out how many rows will be returned?  Do I have to make the
query twice?

Thanks in advance,
Eric

--
Eric
ericco@ssl.berkeley.edu