iBase.ru Forum

Код: Выделить всё

CREATE TABLE IMAGE (
    IMAGE_ID     INTEGER NOT NULL,
    CRC32        BIGINT NOT NULL,
    HEIGHT       SMALLINT NOT NULL,
    WIDTH        SMALLINT NOT NULL,
    BPP          SMALLINT NOT NULL,
    PLANES       SMALLINT NOT NULL,
    COLORS       SMALLINT NOT NULL,
    IMG_SIZE     INTEGER NOT NULL,
    IMG_TYPE     VARCHAR(50) NOT NULL,
    COMPRESSION  VARCHAR(50) NOT NULL,
    IMAGE        BLOB SUB_TYPE 0 SEGMENT SIZE 1024 NOT NULL
);


CREATE TABLE IMAGE_FILENAME (
    IMAGE_ID       INTEGER NOT NULL,
    FILENAME_HASH  VARCHAR(50) NOT NULL,
    FILENAME       VARCHAR(8192) NOT NULL
);

Код: Выделить всё

select 
    * 
from 
    image i 
where 
    i.image_id in (select 
                            f.image_id
                        from 
                            image_filename f
                        group by f.image_id
                        having count(f.filename) > 1 )