[lizzarrd]

Can anyone tell me what is wrong with the seemingly simple statement below??

==============================
Select
DATE(trasnac_date) as Date
, COUNT(*)
From
tb_transaction
Where
company_sn=101
Group by
DATE(transac_date)
=============================


I get a generic Syntax error message...

[ceinma]

DATE(trasnac_date) != DATE(transac_date)

[lizzarrd]

Thanks for the reply.

Although that would have been an easy fix. The syntax error remains (for the following code):

=========================
Select
DATE(transac_date) as Date
, COUNT(*)
From
tb_transaction
Where
company_sn=101
Group by
DATE(transac_date)
=========================

It seems that the error lies in the Group by clause and using functions within it. The following executes without any problems:

=========================
Select
transac_date as Date
, COUNT(*)
From
tb_transaction
Where
company_sn=101
Group by
transac_date
=========================

Thanks in advance,

L

[nog]

try GROUP BY 1

[lizzarrd]

Thanks! so simple....