Custom Query
Posted: Thu May 11, 2017 7:02 am
How to do grouping in servoy?
SELECT id, row_number() OVER (PARTITION BY col1, col2, col3 col4) AS rownr FROM myTable
SELECT id
FROM (
SELECT id, row_number() OVER (PARTITION BY col1, col2, col3 col4) AS rownr FROM myTable
) t
WHERE rownr = 1
foundset.loadRecords("SELECT id \
FROM ( \
SELECT id, row_number() OVER (PARTITION BY col1, col2, col3 col4) AS rownr FROM myTable \
) t \
WHERE rownr = 1");