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 10000 Id FROM posts 
  WHERE Tags like '%java%' and Tags not like '%javascript%' and AnswerCount > 0
  ORDER BY Id desc
  );

fork query

edited jul 30 13 anonymous

created feb 27 11 sysadmin1138