Q&A for administrators, end users, developers and designers for ExpressionEngine® CMS
-- ============================================= -- Author: nasser.fet -- Create date: 2019-05-10 10:00:39 -- Description: Tabriz highest rated stackexchange user -- ============================================= SELECT TOP 100 ROW_NUMBER() OVER(ORDER BY Reputation DESC) AS Rank, Reputation, CreationDate, DisplayName, LastAccessDate, WebsiteUrl, Location, AboutMe --* FROM Users WHERE ( LOWER(DisplayName) LIKE N'%khazeni%' ) ORDER BY Reputation DESC;