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");
Return to Programming with Servoy
Users browsing this forum: Google [Bot] and 9 guests