Friday, October 14, 2011

Character count Query

SELECT a.charcount, count( a.charcount )
FROM (

SELECT notedescription, CHARACTER_LENGTH( notedescription ) AS charcount
FROM iplat_user_notes
) AS a
GROUP BY a.charcount
ORDER BY count( a.charcount ) DESC

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home