OpenOffice.info

Code: Alles auswählen

select * from t_platten p where not exists (select 1 from t_platten e where p.ID_PLATTE = (e.ID_PLATTE - 1))

Code: Alles auswählen

SELECT "Z" MISSING_NUMBERS FROM 
    (SELECT DISTINCT
         cast(A.Z||B.Z||C.Z||D.Z||E.Z as INTEGER) AS Z
     FROM
        (SELECT "ORDINAL_POSITION" -1 Z FROM "INFORMATION_SCHEMA"."SYSTEM_COLUMNS" WHERE "TABLE_NAME" = 'SYSTEM_PROCEDURES') A ,
        (SELECT "ORDINAL_POSITION" -1 Z FROM "INFORMATION_SCHEMA"."SYSTEM_COLUMNS" WHERE "TABLE_NAME" = 'SYSTEM_PROCEDURES') B ,
        (SELECT "ORDINAL_POSITION" -1 Z FROM "INFORMATION_SCHEMA"."SYSTEM_COLUMNS" WHERE "TABLE_NAME" = 'SYSTEM_PROCEDURES') C ,
        (SELECT "ORDINAL_POSITION" -1 Z FROM "INFORMATION_SCHEMA"."SYSTEM_COLUMNS" WHERE "TABLE_NAME" = 'SYSTEM_PROCEDURES') D ,
        (SELECT "ORDINAL_POSITION" -1 Z FROM "INFORMATION_SCHEMA"."SYSTEM_COLUMNS" WHERE "TABLE_NAME" = 'SYSTEM_PROCEDURES') E WHERE Z <=30000)AS "Z"
WHERE 
    "Z" not in (SELECT DISTINCT "Ident" FROM "Bestellungen")
ORDER BY MISSING_NUMBERS LIMIT 50 offset 0

Code: Alles auswählen

SELECT (SELECT COUNT("ID")+1 FROM "ID_Leer" WHERE "ID" <= "a"."ID") AS "CID" FROM "ID_Leer" AS "a"

Code: Alles auswählen

SELECT "x"."CID" FROM 
(SELECT (SELECT COUNT("ID")+1 FROM "ID_Leer" WHERE "ID" <= "a"."ID") AS "CID" FROM "ID_Leer" AS "a") AS "x" 
LEFT JOIN "ID_Leer" 
ON "x"."CID" = "ID_Leer"."ID" WHERE "ID_Leer"."ID" IS NULL

Code: Alles auswählen

SELECT T1.Field1, T2.Field1
FROM T1 LEFT JOIN T2 ON T1.Field1 = T2.Field1
WHERE T2.Field1 Is Null;