Hello,
I am a new user of KNIME and wanted to know how I can execute sql query in it.
I have already uploaded the table of my interest from the DB but I would like to query, how can I do?
help me, please!!!!
You can use either the Database Connector Node or the Database Reader Node. Within the node you need to specify the driver any password (if set) to connect to the database and then you simply add the SQL statement in the box at the lower right. As I understand you can work with most of the SQL statements. The only requirement is that the last statement has to be a select statement. If you use the Database Connector Node you have to connect it to the Database Connection Reader Node in order to get the results as a table you can work with further in Knime.
Hope that helps