Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APPROX_COUNT_DISTINCT Returning extra count values

New RootsNov 27 2017 — edited Nov 27 2017

Hi All,

I am running below query in sql live .

select count(employee_id),

   APPROX\_COUNT\_DISTINCT(last\_name||first\_name) ,

   count(distinct last\_name||first\_name)  

   from hr.employees;

pastedImage_0.png

There are 107 records in the employee table from hr schema . But APPROX_COUNT_DISTINCT is returning 108 rows.

Is this a bug ?

pastedImage_1.png
This post has been answered by Mustafa KALAYCI on Nov 27 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 25 2017
Added on Nov 27 2017
6 comments
260 views