Thursday, 19 September 2013

SQL Command Not Properly Ended driving me bananas

SQL Command Not Properly Ended driving me bananas

I am trying to run this query, but i repeatedly get an error message. Any
suggestions?
SELECT DD_INTERVAL, VENDOR_ID, COUNTRY, "SUM"(VOLUME) as Volume,
"SUM"(COST) as Cost
FROM Table_1
WHERE VENDOR_ID ='35', DD_INTERVAL = '7', COUNTRY =
('idn','lao','mys','phl','sgp','tha','vnm')
GROUP BY DD_INTERVAL, Vendor_ID, COUNTRY;

No comments:

Post a Comment