0

Please login or register to vote for this query.

(click on this box to dismiss)

A lexical search method

Q&A for network engineers

SELECT *
FROM posts
WHERE ParentId IN 
( SELECT Top 1000 Id FROM posts 
  WHERE Tags like '%java%' and Tags not like '%javascript%' 
  ORDER BY Id desc
  )
  AND CreationDate BETWEEN '2013-05-31' and '2013-07-01'
  and AnswerCount > 0

fork query

edited jul 30 13 anonymous

created feb 27 11 sysadmin1138