c_pattle Posted August 6, 2011 Share Posted August 6, 2011 I have a sql statement which is select * from invoices where username="gtd" order by invoice_date I want to edit it so to get the total of a field called "invoice_total" so the statement will now look like this select *, sum(invoice_total) from invoices where username="gtd" order by invoice_date However when I do this I now only get 1 record returned rather than before when I got 5 records returned. Is there are way to get around this problem? Thanks for any help Quote Link to comment Share on other sites More sharing options...
fenway Posted August 6, 2011 Share Posted August 6, 2011 Well, you're missing a GROUP BY column -- based on something like invoice_number, perhaps? But then * is useless. Quote Link to comment Share on other sites More sharing options...
c_pattle Posted August 7, 2011 Author Share Posted August 7, 2011 If I use group by then I don't get the overall total but just the total for each record. Would you recommend just having a seperate sql statement? Quote Link to comment Share on other sites More sharing options...
fenway Posted August 8, 2011 Share Posted August 8, 2011 You can use the "WITH ROLLUP" modifier to GROUP BY if you'd like. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.