Q&A BY TAG 'Distinct'

You must sign in to ask a question. If you do not have an account, you can register here

Distinct clause issue
answered 03-12-2021 08:12:37 -0500

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...

Answers: 1


How to select distinct elements of an array column in a view
answered 04-03-2021 04:55:15 -0500

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 ...

Answers: 3

ARRAY Distinct #array #customfunction

Select Distinct records based on a particular value in another column
answered 06-10-2020 08:23:23 -0400

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 ...

Answers: 1

Distinct order by

How to access unique/distinct values from the column in a Base view in RESTful web service?
answered 10-05-2018 06:18:56 -0400

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...

Answers: 1


SELECT DISTINCT Doesn't work in subquery
answered 14-02-2017 06:51:00 -0500

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...

Answers: 1

subquery Distinct