[Solved] Row_Number()
Posted: Mon Jul 02, 2018 5:44 am
In Base, is there a way to perform a row_number function similar to the one described at http://www.sqlserver.info/syntax/row_nu ... to-use-it/?
User community support forum for Apache OpenOffice, LibreOffice and all the OpenOffice.org derivatives
https://forum.openoffice.org/en/forum/
Code: Select all
SELECT COUNT(T2."Field1") AS "RowNum", T1."Field1", T1."Field2", T1."Field3", ...
FROM "Table1" T1
LEFT JOIN "Table1" T2
ON ( T1."Field1" >= T2."Field1" )
GROUP BY T1."Field1", T1."Field2", T1."Field3", ...
Code: Select all
SELECT COUNT(T2."Field1") AS "RowNum", T1."Field1", T1."Field2", T1."Field3", ...
FROM "Table1" T1
LEFT JOIN "Table1" T2
ON ( T1."Field1" >= T2."Field1" )
AND T1."Field3" = T2."Field3"
GROUP BY T1."Field1", T1."Field2", T1."Field3", ...
Code: Select all
SELECT COUNT(T2."Field1") AS "RowNum", T1."Field1", T1."Field2", T1."Field3", ...
FROM (select LEFT(A."Field3",3) as "Part", A.* from "Table1" A ) T1
LEFT JOIN (select LEFT(A."Field3",3) as "Part", A.* from "Table1" A ) T2
ON ( T1."Field1" >= T2."Field1" )
AND T1."Part" = T2."Part"
GROUP BY T1."Field1", T1."Field2", T1."Field3", ...