Re: Keeping Result Table

In article <1995Aug4.104459.2232_at_figmnt.tayloru.edu> dganderso_at_figmnt.tayloru.edu (Doug Anderson) writes:

> Also, is there a better way to do the following? I wish to show the average
> number of rows per block for a given table. This is all that I could come
> up with...
>
> CREATE VIEW TMPVIEW
> AS select count(*) ZORK
> from &tablename
> group by substr(rowid,1,8);
>
> SELECT AVG(ZORK)
> FROM TMPVIEW;
>
> DROP VIEW TMPVIEW;
Yes. Try

   SELECT AVG(ZORK)

      FROM (select count(*) ZORK
              from &tablename
              group by substr(rowid,1,8));

-- 
==============================
Mark Grand              Voicemail: 1-800-RAPID60
RSSI