Statistics

0

Please login or register to vote for this query.

(click on this box to dismiss)

Woodworking

Q&A for professional and amateur woodworkers

/*select top p.PostTypeId, 
Prog_Language as 
from Posts as p
where Tags = '<c#>' or Tags = '<java>'
*/
--select * from PostTypes

select
      Title,
      IIF(Tags like '%c#%', 'C#', 'Java') as Language,
      Tags,
      CreationDate,
      Score
      
from Posts
where (Tags like '%<c#>%' or Tags like '%<java>%')
  and PostTypeId = 1
  and Year(CreationDate) = 2012 
  and Month(CreationDate) = 10

Enter Parameters

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