Lists the top 100 users (ranked by reputation) that are located in Greece according to their profile information. A range of options is used to pinpoint members from Greece based on popular locations used.
プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答
-- TOP 100 users from Greece -- Lists the top 100 users (ranked by reputation) that are located in Greece according to their profile information. -- A range of options is used to pinpoint members from Greece based on popular locations used. SELECT TOP 100 Id as [User Link], DisplayName, Reputation, WebsiteUrl, Location FROM Users WHERE Location like N'%Thess%' OR Location like N'%Greece%' OR Location like N'%Gr' OR Location like N'%Patra%' OR (Location like N'%Athens%' AND Location NOT like N'%GA%') ORDER BY reputation DESC