In Select by Attributes, can do a SELECT IN statement with mdb or SDE with:
[NAME] IN
(SELECT [NAME]
FROM RoadLinework_FC As Tmp
GROUP BY [NAME]
HAVING Count( [NAME]) > 1)
fgdb has issues with certain SQL functions. While most work, others (including "GROUP BY") don't.
This is really RDBMS dependent (also for syntax).
And when it can be done, biggest trick is to ensure a 1:1 return, not 1:many or many:1.
Or, as said above, "It's fixed in 10"