1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

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