Quiero seleccionar todas las filas que comienzan después de un uuid específico, por ejemplo, aquí están los datos
+--------------------------------------+-----------+------------+ | uuid | divisi_id | divisionid | +--------------------------------------+-----------+------------+ | b303a96b-2a03-4b5e-90a1-6b3631fc82af | BTT | 3 | | 8c4bf1b8-7477-42e4-affb-31bafa8648f1 | BTT | 3 | | 6639909d-74e1-4dec-a1f3-f70703c0b6c6 | BTT | 3 | | 1a1aa367-1467-4811-848d-694dbe98a5a8 | BTT | 3 | | e739b352-d952-4ec8-980e-a50180e18144 | BTT | 3 | +--------------------------------------+-----------+------------+ ahora, por ejemplo, tengo el último uuid = 8c4bf1b8-7477-42e4-affb-31bafa8648f1 (la segunda entrada). ¿Cómo seleccionar filas después de ese uuid? no tengo idea al respecto
Prueba esto
SELECT d1.* FROM (SELECT Row_Number() over (order by id) AS RowIndex, * from tableName ) AS d1 INNER JOIN (SELECT Row_Number() over (order by id) AS RowIndex, * from tableName) AS d2 ON (d2.uuid = '8c4bf1b8-7477-42e4-affb-31bafa8648f1' and d1.RowIndex > d2.RowIndex)¡Espero que tengas la clave principal!
Si no tiene clave principal que
SELECT d1.* FROM (SELECT Row_Number() over (order by (select null)) AS RowIndex, * from tableName) AS d1 INNER JOIN (SELECT Row_Number() over (order by (select null)) AS RowIndex, * from tableName) AS d2 ON (d2.uuid = '8c4bf1b8-7477-42e4-affb-31bafa8648f1' and d1.RowIndex > d2.RowIndex)