Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
peter134
Starting Member
3 Posts |
 Posted - 2008-10-23 : 18:50:35
|
| hi any one can help me to write this??write a selct stetment that answers the following question: what is the total amonut invoised for each accountNo?use the with rollup operator to include a row that gives the grand total.use the invoiselineitemamount column of the invoicelineitems table. |
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-10-23 : 18:58:09
|
| some kind of exam?? no cheat cheat... Don't just paste the question, provide us more info.. |
 |
|
|
peter134
Starting Member
3 Posts |
Posted - 2008-10-23 : 19:06:26
|
| yes it is fo rthe school do you have any idea |
|
|
|
hanbingl
Aged Yak Warrior
652 Posts |
Posted - 2008-10-23 : 19:34:53
|
| Here's some reading for you... almost same as your question...http://www.w3schools.com/sql/sql_groupby.asp |
|
|
|
|
|
|
new for SQL