Users by Location (Updated)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

SELECT ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS Ind, * 
FROM Users 
WHERE LOWER(Location) LIKE LOWER(('%##Location##%'))
AND LOWER(AboutMe) LIKE LOWER(('%##content##%'))
ORDER BY Reputation, Id DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results