D Cube Analytics Interview Question | Duplicate Rows

Question

If a table contains duplicate rows, does a query result display the duplicate values by default? How can you eliminate duplicate rows from a query result?

in progress 0
Dhruv2301 55 years 1 Answer 926 views Great Grand Master 0

Answer ( 1 )

  1. Prerana
    0
    Reply

    By using distinct() window function on column that has unique value like id, order number,

Leave an answer

Browse
Browse