title

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow em Português

Perguntas e respostas para programadores profissionais e entusiastas

SELECT 
    Id,Body,Tags,ViewCount,CreationDate
FROM
    Posts
WHERE 
PostTypeId = 1 and Tags LIKE('%c#%') and ViewCount>10000
AND CreationDate
BETWEEN'01-01-2010' and '01-01-2011'
    
UNION ALL 
SELECT
    Id,Body,Tags,ViewCount,CreationDate

FROM Posts

WHERE ParentId IN
(
SELECT  
    Id
FROM
    Posts
WHERE 
PostTypeId = 1 and Tags LIKE('%c#%') and ViewCount>10000
AND CreationDate
BETWEEN'01-01-2010' and '01-01-2011'
)

Enter Parameters

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