SQL & PL/SQL

SQL> SELECT * FROM (SELECT employee_id, COUNT( employee_id) OVER ( PARTITION BY employee_id) cnt
FROM all_employees@ougt1prd
) Where Cnt> 1


out put is total rowcount 448


SQL > SELECT employee_id, COUNT(employee_id) cnt
FROM all_employees@ougt1prd
having COUNT(employee_id)> 1
group by employee_id;

out put is total rowcount 219



im trying to count the employee_id group by employee_id , i used above query's but each gives me diffrent answer's ?

any idea why the out put chages , the functionality are same for both...



thanks,

Raj