Q&A BY TAG 'Distinct'

Hello. I have a view named left_view with 5 rows: column_1 column_2 column_3 abc some value some value def some value some value ghi some value some value ...

Duplicates Distinct primary keys join left join

Hi Team, I'm using Denodo 7.0 Facing issue with Distinct function. we have a join view which is working fine without Distinct clause. When we apply Distinct in code and saved, we getting error while executing which says something like ' 75576 limit e...

Distinct

I need to select distinct values from few array columns in a view. My view consists few Array columns and I cannot group by them. SELECT * from {view} where {parameter} = '03645' Parameter Column 2 Column 3 Column 4 ...

ARRAY Distinct #array #customfunction

I have a result of employees with "employee id" that has duplicates. I have another column called "leader level" i want to keep unique records of the employee id that has the lowest value of leader level (i.e. if the same employee id is in row 1 and 2 ...

Distinct order by

I have added a base view in REST web service. How to access DISTINCT values of a particular column from that base view? Currently I am seeing entire base view here: http://servername:port/denodo-restfulws/database/views/baseview Representaion: JSON VQL...

REST API REST Distinct

Hello, Whenever I try running a subquery with SELECT DISTINCT I get the following error message: Query Execution failed Reason: SQL ERROR -50006 [HY000]: Error executing view: Functions min, rank are not executable I'm not sure why this is hap...

subquery Distinct