Icon

15_​Advanced_​Query_​Building

Advanced Query Building
Perform many complex in-database data manipulation operations using your own custom SQL statements SELECT * from WebActivityconnect toH2 databaseadd a new IncomeCategorycolumngroup by Productscount occurrenceswhere NumberOfContracts > 1take only 2 products withthe most occurrencesfilter the input DB byonly taking rows related tothe 2 products with highestoccurrencesremove rows whereProducts = Private Investment DB Table Selector H2 Connector DB Query DB Query Reader ParameterizedDB Query Reader DB SQL Executor Add backdeleted rows Perform many complex in-database data manipulation operations using your own custom SQL statements SELECT * from WebActivityconnect toH2 databaseadd a new IncomeCategorycolumngroup by Productscount occurrenceswhere NumberOfContracts > 1take only 2 products withthe most occurrencesfilter the input DB byonly taking rows related tothe 2 products with highestoccurrencesremove rows whereProducts = Private InvestmentDB Table Selector H2 Connector DB Query DB Query Reader ParameterizedDB Query Reader DB SQL Executor Add backdeleted rows

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: dewi
Created at: 2019-11-12
On NodePit since: 2020-09-11
Last update: 2024-04-25
Created with KNIME version: v4.5.0
Tags: databaseSQLcustom queryutility

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!