Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
Informix syntax query
It seems that the error is in the Group by Clause.- lizzarrd
- Post #3
- Forum: Informix solutions
-
Informix syntax query
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)...- lizzarrd
- Thread
- Replies: 4
- Forum: Informix solutions
