Posted By

flatearthcomms on 12/02/08


Tagged


Versions (?)

Select longest string


 / Published in: SQL
 

  1. SELECT lemma FROM word WHERE (LENGTH(lemma)-LENGTH(REPLACE(lemma,' ','')))=(SELECT MAX(LENGTH(lemma)-LENGTH(REPLACE(lemma,' ',''))) FROM word);

Report this snippet  

You need to login to post a comment.