-- Collection of code snippets by Arne Vajhøj 
-- (likely posted to comp.os.vms/INFO-VAX, INFO-TPU, MACRO32, eksperten.dk, newz.dk, LinkedIn or other place sometime between 1990 and now) 
SELECT * FROM t1;
SELECT * FROM t1 a JOIN t1 b ON a.f1=b.f1;
SELECT * FROM t1 a JOIN (SELECT * FROM t1 b ORDER BY f1 LIMIT 2) x ON a.f1=x.f1;
