1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to bypass life's everyday problems with simple tricks

SELECT

    ROW_NUMBER() OVER (ORDER BY Reputation DESC) AS 'ID', 
    --Id [User Link], 
    DisplayName AS 'Name',
    Reputation AS 'Rep',
    UpVotes AS 'Up',
    DownVotes AS 'Down',
    Views AS 'Views',
    CreationDate AS 'Since',
    LastAccessDate AS 'Last Seen',
    Location AS 'Location',
    Id AS 'SO ID',
    AccountId AS 'SE ID'

FROM Users

WHERE LOWER(Location) LIKE '%croatia%' 
OR LOWER(Location) LIKE '%hrvatska%'

ORDER by Reputation DESC, LastAccessDate DESC, CreationDate DESC

fork query

edited feb 27

created feb 24 VBasic2008