If you want to use OVER like in an SQL code you might use a database node but this would depend on the implementation of window functions in your database.
One example of using OVER just with KNIME resources is shown in this thread using a local big data environment.
You might want to add some further details about what you are looking for.