0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT    U.range as [display name length],
          count(*) as [number of occurences],
          Round((U.range/600.0)*100,1) as [character limit percentage used]
FROM
(
SELECT len(replace(displayname,' ','')) as range
  FROM   Users
  WHERE displayname != '' and displayname is not null
) U
GROUP BY U.range
ORDER BY U.range

fork query

edited feb 14 14

created feb 13 14 Sly Raskal