Re: questions on the COUNT()
Yes.
SELECT count( * )
FROM dog g, kennel k
Returned 12. (I have four dogs and three kennels.) Of course, that is a matrix, and therefore not accurate. If, instead, I did this:
SELECT count( * )
FROM dog g, kennel k
WHERE g.kennel_id = k.kennel_id
Returned 4.
(I had no clue to the answer, so I set up a quick test in about three minutes ...)
Subject
Written By
Posted
February 28, 2005 11:19AM
Re: questions on the COUNT()
February 28, 2005 11:38AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.