Test Query

0

Please login or register to vote for this query.

(click on this box to dismiss)

Test query to check whether stack overflow can be used to find potential candidates.

Gardening and Landscaping

Q&A for gardeners and landscapers

SELECT DISTINCT TOP(200) Users.*, Tags
  from Users inner join Posts on Users.Id=Posts.OwnerUserId where
  
  Reputation>100 and -- Basic skill check.
  Location like '%India%' and --Filter for Indian candidates.
  AboutMe like '%Zoho%' and --Don't search for who is already at Zoho.
  --UpVotes>20 and --We want an encouraging person.
  --DownVotes<2000 and --We don't want a person who discourages heavily.
  AboutMe<>'' and
  Reputation<>'' and
  Tags<>'' --and 
  --(Tags like '%java%' or Tags like '%mysql%') --Targeted skill check.
  order by Reputation DESC, DownVotes; --Best, polite first.

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results