0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for committed Christians, experts in Christianity and those interested in learning more

/*
SELECT 
count

FROM
Posts

Where
PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') 
AND CreationDate
BETWEEN'01-01-2013' and '01-01-2014'

/*

SELECT TOP 14983
Id,ParentId,Body,Tags,ViewCount,CreationDate
FROM
    Posts
WHERE 
PostTypeId = 1 and Tags LIKE('%java%') and Tags NOT LIKE('%javascript%') 
AND CreationDate
BETWEEN'01-01-2017' and '01-01-2018'

ORDER BY [ViewCount] Desc

*/

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

FROM Posts

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

ORDER BY [ViewCount] Desc)

fork query

edited jul 20

created feb 4 anonymous