Select longest string - SQL Snipplr Social Repository

Revision: 9979

at December 2, 2008 06:50 by flatearthcomms

Initial Code

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

Initial URL

Initial Description

Initial Title

Select longest string

Initial Tags

Initial Language

SQL