0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who like playing board games, designing board games or modifying the rules of existing board games

SELECT Creationdate, CONCAT(YEAR(CreationDate),MONTH(CreationDate)) as Periods
FROM Posts




/*SELECT Count(ID) as Skaits
FROM Users
WHERE UPPER(DisplayName) LIKE 'ANDR%'*/



/*SELECT Count(ID) as Skaits
FROM Posts
WHERE CreationDate BETWEEN '2019/01/01 00:00:00' AND '2019/12/31 23:59:59'*/


/*SELECT DISTINCT TagID, TagName
from PostTags
INNER JOIN Tags
ON PostTags.TagID=Tags.ID
ORDER BY TagID*/

fork query

edited dec 6

created dec 6 anonymous