Re: number of rows query.

Jerome Vitalis ha scritto:

> Ale wrote:
> > hi there,
> > I'm a beginners and so please let me post this orrible stupid
> > question:
> > I have to do a quary that return the count (integer) of a row returned
> > from a query like
> > select * from db where ... is it possible?
> > And how to do this?
> > cheers
> > --Alessio
> >
>
> Just use the count function:
>
> select count(*) from db;
> or
> select count(column_name) from db;
> or
> select count(1) from db;
> or ...etc...
>
> (With recent versions of Oracle, it does not matter which one you choose
> ; with older versions, the performance of each of those queries might
> have varied.)

Yes Yes Yes
 it work ok
thanks a lot Jerome
--Alessio. Received on Fri Jul 28 2006 - 10:17:38 CDT