Get 100 longest usernames

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT TOP 100 Id, DisplayName, LEN(DisplayName) as Length FROM Users
ORDER BY LEN(DisplayName) DESC

edited feb 23 16

created feb 23 16

Patrick.Westerhoff

Options: Text-only results Include execution plan

Switch to meta site

Hold tight while we fetch your results

Results[:current/:total] Messages Graph Execution Plan

Download CSV Download XML

:records returned in :time ms:cached