Re: Help with select statement

A few people responded that I needed to move the count( extent_id ) > 20 to a trailing 'having' statement thru email only.

That did it.
Thanks.

where ( owner like 'MANU%' or owner like 'ACCOUNT%' ) and count( extent_id )
>20

group by owner, segment_name, segment_type

     \/
select owner, segment_name, segment_type, count( extent_id ) from dba_extents
where ( owner like 'SYS%' or owner like 'ACCOUNT%' ) group by owner, segment_name, segment_type having count( extent_id ) > 20

stantow_at_ibm.net Received on Thu Jun 05 1997 - 00:00:00 CDT