Latest Activity

code

dense rank

get the 5TH highest annualincome

  • Answers: 1
  • answered 17-04-2023 19:31:44 -0400

Rownum() Over & Rank() Over order by

code

using order by clause in denodo vql

Hi , I want to use this query in my vql in denodo. SELECT * FROM finance."ProjectStatusCs" order by WBSInternalNbr limit 10 but it gives this error : Error in ORDER BY clause: Invalid field name: wbsinternalnbr can someone please help

  • Answers: 1
  • answered 13-02-2023 15:41:49 -0500

order by

code

Select Distinct records based on a particular value in another column

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
  • answered 06-10-2020 08:23:23 -0400

Distinct order by

code

Denodo order by issue when partial cache enabled.

Hello, guys. I faced with the weird issue when enabling denodo cache (partial mode) in the following case: Created two tables in MS SQL Server and imported it to Denodo: create table dbo.Denodo_Bug_View1 ( ColumnId bigint not null identity(1...

  • Answers: 1
  • answered 21-11-2017 06:33:14 -0500

Partial cache order by

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