title

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

/*
SELECT 
Id,ParentId,Body,Tags,ViewCount,CreationDate
FROM
    Posts
WHERE 
PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') 
AND CreationDate
BETWEEN'05-02-2017' and '06-01-2017'


*/



SELECT
Id,ParentId,Body,Tags,ViewCount,CreationDate

FROM Posts

WHERE ParentId IN
(
SELECT 
    Id
FROM
    Posts
WHERE 
PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') 
AND CreationDate
BETWEEN'05-02-2017' and '06-01-2017')

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results