Hi All,
Am very new to infomrix and was wondering if anyone could tell me what is wrong (syntax-wise) with the following query:
========================================
Select
DATE(transac_date) as Date,
, COUNT(*)
From
tb_transaction
Where
company_sn = 101
Group by
DATE(transac_date)
========================================
If I remove the DATE() function the query runs fine, but with the function it produces a syntax error message.
Any help here is greatly appreciated!!
L
Am very new to infomrix and was wondering if anyone could tell me what is wrong (syntax-wise) with the following query:
========================================
Select
DATE(transac_date) as Date,
, COUNT(*)
From
tb_transaction
Where
company_sn = 101
Group by
DATE(transac_date)
========================================
If I remove the DATE() function the query runs fine, but with the function it produces a syntax error message.
Any help here is greatly appreciated!!
L