Re: Select count(*)

Matthias Gresz wrote:
>
> 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 :-)

 Did I fell in coma?

-- 
Regards

Matthias Gresz    :-)