Re: [Q]HowTo get the count of selected rows

Paulo Martins da Costa sent me the solution to this.

	Select count(*)
	from (SELECT DISTINCT fld1,fld2 FROM table1);

Thanks Paulo!

Randall Smith

> Is it possible to construct a new SQL statement from an arbitrary
> SELECT statement which will always simply return the number of rows
> which would be selected by the original query?
  Received on Fri Mar 14 1997 - 00:00:00 CST