Friday, March 23, 2007

SQL is fun for the whole family

five-gram: a string containing 5 "words"...

you get a dollar if you can explain to me what this does, dinner if you are a girl ;)

select f1.g1,f1.g2,f1.g3,f1.g4,f1.g5,f2.g5 from five_gram as f1, five_gram as f2 where f1.g2=f2.g1 and f1.g3=f2.g2 and f1.g4=f2.g3 and f1.g5=f2.g4 limit 5;

Labels: , ,


Post a Comment

<< Home