Archives of the TeradataForum
Message Posted: Sun, 17 Jul 2005 @ 08:58:56 GMT
Am trying to run the query below but its giving me an error saying "expecting something between ( and the select word"
select x , count(x) from x where date BETWEEN ( Select Max(rec_date) from y) and ( Select add_months(Max(rec_date + 1), -3) - 1 from y) + 1), -3) - 1 from A_AFRICA_BASE.accounts) group by 1 order by 1;
Could you please help.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|