CREATE CURSOR (Shi1) (filenameid c (10), shingles n(10), shingt m)

CREATE CURSOR sim (doc1 n(3), doc2 n(3), doc1_count n(3), doc2_count n(3))
INSERT INTO sim;
SELECT a.id as doc1, b.id as doc2, 0, 0 FROM (t a INNER JOIN t b ON a.num=b.num AND a.id<b.id )
CREATE CURSOR counts (doc_id n(3), kolvo n(3))
INSERT INTO counts;
SELECT id as doc_id, count(*) FROM t GROUP BY id
CREATE CURSOR sim2 (doc1 n(3), doc2 n(3), doc1_count n(3), doc2_count n(3))
INSERT INTO sim2;
SELECT sim.doc1, sim.doc2, counts.kolvo as doc1_count, 0 FROM sim, counts WHERE sim.doc1 = counts.doc_id
CREATE CURSOR sim3 (doc1 n(3), doc2 n(3), doc1_count n(3), doc2_count n(3))
INSERT INTO sim3;
SELECT sim2.doc1, sim2.doc2, sim2.doc1_count, counts.kolvo as doc2_count FROM sim2, counts WHERE sim2.doc2 = counts.doc_id
SELECT doc1, doc2, count(*) / (doc1_count + doc2_count), count(*) from sim3 GROUP BY doc1, doc2

* Делай раз
SELECT a.id AS id1, ;
 b.id AS id2, ;
 COUNT(*) AS cnt_num ;
 FROM t a INNER JOIN t b ;
  ON a.num=b.num AND ;
     a.id < b.id ;
 GROUP BY a.id, b.id ;
 INTO CURSOR csr1
* Делай два
SELECT id1, ;
 id2, ;
 0.0000000000 + 1/SUM(1/cnt_num) as sim ;
 FROM csr1 INNER JOIN t ;
  ON t.id = csr1.id1 OR ;
     t.id = csr1.id2 ;
 GROUP BY 1, 2 ;
 INTO CURSOR csr2
BROWSE