Syntax for SUM() Functions
Hi:
I have a WADA results page with the following SELECT statement:
SELECT *
FROM pslip
WHERE username = colname
The table “pslip” includes the following columns: mmk, usdCash, overseas, retain and hold.
Now I would like to add a SUM() function for each of those columns to show the different totals pertaining to that particular user (colname).
Where should I enter the SUM() statements? Before or after the WHERE username = colname code? What would be the right syntax? I have tried a couple of ways but I always get syntax error messages.
Thank you for your attention