msi77 wrote:
> Hi,
>
> SELECT
> (SELECT COUNT(distinct model) FROM inventory WHERE modified >= '2010-02-01')
> as count1,
> (SELECT COUNT(distinct model) FROM inventory WHERE modified >= '2010-01-20')
> as count2,
> (SELECT COUNT(distinct model) FROM inventory WHERE modified >= '2010-01-01')
>
Hi,
SELECT
(SELECT COUNT(distinct model) FROM inventory WHERE modified >= '2010-02-01') as
count1,
(SELECT COUNT(distinct model) FROM inventory WHERE modified >= '2010-01-20') as
count2,
(SELECT COUNT(distinct model) FROM inventory WHERE modified >= '2010-01-01') as
count3
Serge
> Good Evenin
Hi,
SELECT
(SELECT COUNT(distinct model) FROM inventory WHERE modified >= '2010-02-01') as
count1,
(SELECT COUNT(distinct model) FROM inventory WHERE modified >= '2010-01-20') as
count2,
(SELECT COUNT(distinct model) FROM inventory WHERE modified >= '2010-01-01') as
count3
Serge
> Good Evenin
Good Evening, Good Morning Wherever you are whenever you may be reading this.
I am new to this email group and have some good experience with SQL and
PostgreSQL database.
I am currently working on a PHP / PostgreSQL project and I came upon something
I could not figure out in SQL. I was wonderi
