1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

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