Otieno_Onyango Member

@GrantSmith what made me raise a red flag on this is the fact that in DOMO I get a different result than the one on my DB client, my expectation was to have the same error in the two instances if there was one but it only occurs in DOMO, also having nulls should affect both instances, not one. You have a point, I haven't…

@GrantSmith the query works perfectly as an alternative for window function, my issue is when I write the same in DOMO, it doesn't populate the debitor_id column, and also the result is not ordered by the debtor_id.

@jaeW_at_Onyx , as you can see clearly the order by, is on a.debitor_id on the image above FYI this is an alternative way of writing a query that would need windows function to achieve the same results and since DOMO uses a MySQL that doesn't support windows function thus the query, also please understand the query before…

@jaeW_at_Onyx this is the same query giving me the desirable output on a DB client.

@jaeW_at_Onyx yes

@jaeW_at_Onyx I'm expecting 3 columns but as you can see, only 2 are being populated and the order by also is not being applied as expected. the MySQL version is 5.6.37-82.2-82.2, my issue is with the output not the version of MySQL

@jaeW_at_Onyx I'm expecting 3 columns but as you can see, only 2 are being populated and the order by also is not being applied as expected. the MySQL version is 5.6.37-82.2-82.2, my issue is with the output not the version of MySQL