Hi everybody. (MVS / platinum / spufi / db2v7)
I have a query to ask you
My table named TABLE has these colums in the index
- TABLE_CLIENT_NAME
- TABLE_CLIENT_CARS
- TABLE_CLIENT_BILL_NUMBER
For example we can have
DUDE / PORSCHE / 001
DUDE / PORSCHE / 002
DUDE / PORSCHE / 003
DUDE / FERRARI / 001
DUDE / MASERATI /001
MIKE / BUICK / 001
MIKE / BUICK / 002
PAM / CORVETTE / 001
I want to know the number of rows of this TABLE
GROUP BY TABLE_CLIENT_NAME and TABLE_CLIENT_CAR
The query should gave me 5
I try to make select count(*) from (select distinct (table_client_name, table_client_cars) from TABLE)
Thanks for your reply

This should work:

select count(*) from
(select distinct table_client_name, table_client_cars from TABLE) A

It works fine !!
Thank you so much.

I don't understand why should we type the "A" at the end of the query.

If you use a nested table expression, you have to add a correlation name.
It doesn't matter what the name is ( "A" or "HUGO" or "THISISANAME" or whatever you want ) but you have to add it for syntax reasons.

Thanks for th explanation
Cheers