Re: Select count(*)

Johnny Taxén wrote:
>
> Hello
>
> I´m trying to do, probably a very simple SELECT command. But i just
> can´t
> get it to work. I want to do a SELECT COUNT(*) that displays only the
> tables that have any rows.
>
> Regards/Johnny T

Hi,

ever tried

select

        a.table_name, a.number_rows
from

	(select 
		count(*) number_rows, table_name
	 from
		user_tables
	 group by
		table_name
	) a
where 
	a.number_rows > 0

-- 
Regards

Matthias Gresz    :-)