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.

Open Data

Q&A for developers and researchers interested in open data

SELECT TOP(30) 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 not 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.
  WebsiteUrl<>'' and
  AboutMe<>'' and
  ProfileImageUrl<>'' 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 sites:
loading Hold tight while we fetch your results