SQL IN KNIME - IMPOSSIBLE TO EXTRACT DATE MIN WITHIN AN ORACLE DATABASE???

[crnico]

Hello knime community,
I’m facing an issue when calling to an oracle database, I’ve a (huge) table within which I need to request on the minimum date but this is not working…
I’ve tried the following code :

SELECT
column 1
min (column 2) <- which contain the date
FROM
Table 1
GROUP BY
column 1

the request is working but the result is … nothing… can someone help me with this?

Regards,

[crnico]

I’ve also tried with the db groupby node and still the same. It returns no value.

[pigreco]

Which nodes are you using?
Can you attach workflow export?

[crnico]

Hello pigreco,
Actually I was selecting a wrong item within my SQL code (a type of billing which doesn’t exist within this oracle database). So now this is perfectly working!
Sorry to bother for nothing

[ipazin]

Hi there @crnico,

glad you figured it out and no issues opening a topic for it. Just describing and talking about problem can help (this sound like Oprah ). But caps lock is probably not necessary

Br,
Ivan

[crnico]

Thanks ipazin I will remember about caps lock
This was me grumpy in the morning because I wasn’t able to make it work
But Knime is really awsome and this works perfectly.