Re: COunt problem
- From: Daniel Fink <dan.fink@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 14 Jun 2005 06:33:47 -0600
You could also use a scalar subquery.
SELECT
(SELECT COUNT(idcode) FROM emp) emp_count,
(SELECT COUNT(idcode) FROM emp_dis) emp_dis_count
FROM dual;
Regards,
Dan Fink
Mercadante, Thomas F (LABOR) wrote:
>Kean,
>
>You can do it this way:
>
>Select emp_count, emp_dis_count
>
>From (
> select count(a.idcode) emp_count
> from emp
> ),
> (
> select count(b.idcode) emp_dis_count
> from emp_dis b
> )
>
>Your method is performing a Cartesian join involving both tables. The
>result would be bad.
>
>Tom
>
>
>-----Original Message-----
>From: oracle-l-bounce@xxxxxxxxxxxxx
>[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kean Jacinta
>Sent: Monday, June 13, 2005 10:29 PM
>To: oracle-l@xxxxxxxxxxxxx
>Subject: COunt problem
>
>Hi ,
>
>I am trying to do a count on 2 table at the same time.
>
>select count(a.idcode), count(b.idcode)
>from emp a, emp_dis b
>
>The result return are not corrent. Both idcode
>datatype is number.
>
>Actual table count for emp : 15
>Actual table count for emp_dis :25
>
>Thank You
>JK
>
>
> =09
>__________________________________=20
>Yahoo! Mail=20
>Stay connected, organized, and protected. Take the tour:=20
>http://tour.mail.yahoo.com/mailtour.html=20
>
>--
>//www.freelists.org/webpage/oracle-l
>--
>//www.freelists.org/webpage/oracle-l
>
>
>
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
