Re: [QUESTION] SQL*Plus: Joins

Frampton Steve R wrote:
>
> Hello:
>
> What is the proper way of doing something like this:
>
> select count(a.employee_id) male, count(b.employee_id) female
> from employee_table a, employee_table b
> where a.gender = 'M'
> and b.gender = 'F';
>
> The statement as above return huge values that do not represent
> actual counts. If the statement is broken up into two select
> statements, the correct numbers are returned.
>

Try doing it this war

select gender,count(*) from employee
group by gender;

-- 

Regards,

Varad Acharya