DISTINCT gives duplicate values

2 votes

1 answer

1053 views

                          Can it be considered a bug? This query gives duplicate values despite DISTINCT:

    select distinct '1'
    from 
    (
    select *
    from dual
    connect by level <= 10
    )
    order by dbms_random.value
    fetch first 10 rows only

I understand it creates additional column with random values and uses distinct with two columns, but still I expect to get unique values.
                        

Asked by Andy DB Analyst (110 rep)

Jun 2, 2023, 02:47 PM
Last activity: Mar 13, 2024, 03:01 PM

DISTINCT gives duplicate values

Related Questions