hi,
i have the requirement as following.
SELECT COLUMN1,
COUNT(DISTINCT((COLUMN2||COLUMN3||COLUMN4))),
SUM(CAST(COLUMN5 AS INTEGER)))
FROM TABLE_NAME
GROUP BY COLUMN1
HAVING COLUMN1 <> 'VALUE'.
all columns are of char type. column5 length is 8. column5 contains numeric data only.
The query is not working. error is as follows.
QUERY MESSAGES:
An invalid character string argument was used with the INTEGER function.
if HAVING COLUMN1 = 'VALUE' is given it is working
for having column1 not equal to value, the query is not working. please suggest me on this.
thanks in advance