Hub
ComponentComponent

SQL Lag

Last edited: 

Drag & drop
Like
Use or download
Copy short link
Compute the LAG() function in a DB table in a Azure Database or Microsoft SQL server Database

Component details

Input ports
  1. Type: DB Data
    DB Query Port
    Port with DB Query Information.
Output ports
  1. Type: DB Data
    DB Query with Lagged Column
    The output por with a Lag column

Used extensions & nodes

Created with KNIME Analytics Platform version 4.2.2
  • KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.2.2

  • KNIME Database Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.2.1

  • KNIME Quick Forms Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.2.2