, Guest>> || || |
/ Microsoft SQL Server
    [new]
rage.about
Member

:
: 2
. , , . :

ࠠ 򠠠
first.comuser3product12016-02-29
second.comuser5product32016-04-21
second.comuser1product22016-06-30
first.comuser4product22015-02-23
second.comuser7product32016-04-21
second.comuser3product22015-02-23

, :

ࠠ򠠠 蠠
first.comproduct12016-02-291
second.comproduct32016-04-212
second.comproduct22016-06-301
first.comproduct22015-02-232

, , , . .
22 17, 19:33[20425365]      |
 Re:   [new]
xenix
Guest
SELECT C.SITE, C.PRODUCT, C.PURCHASEDATE,COUNT(C.USERR)
FROM TABLEC C
GROUP BY C.SITE, C.PRODUCT, C.PURCHASEDATE
22 17, 19:42[20425380]      |
 Re:   [new]
rage.about
Member

:
: 2
. , , .
22 17, 20:29[20425458]      |
 Re:   [new]
rnk
Member

:
: 126
rage.about
. , , .

select ... MONTH(C.PURCHASEDATE) as PURCHASEMONTH,YEAR(C.PURCHASEDATE) as PURCHASEYEAR
... group by MONTH(C.PURCHASEDATE),YEAR(C.PURCHASEDATE)
25 17, 14:41[20432901]      |
/ Microsoft SQL Server