Select longest string


/ Published in: SQL
Save to your folder(s)



Copy this code and paste it in your HTML
  1. SELECT lemma FROM word WHERE (LENGTH(lemma)-LENGTH(REPLACE(lemma,' ','')))=(SELECT MAX(LENGTH(lemma)-LENGTH(REPLACE(lemma,' ',''))) FROM word);

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.