-
create row and calculate column
Dear expert
I need your support to help me fix this . in my qurey
i have column has list of number as showing below
i need to to create a row to sum all column .... I couldn't do it with crosstab qry.
Credit Card Type SumOfCommission CountOfStatus
TAYSEER T12 CLASSIC 52 52
TAYSEER T12 GOLD 57 57
Thanks.
-
What's the result you like to see?
-
SELECT basic,hra,pf,SUM(basic+hra+pf) AS netsalary FROM salaryreport GROUP BY basic,hra,pf
basic hra pf netsalary
----- --- ---- -------
5,000 300 400 5,700
5,100 310 110 5,520
5,200 320 120 5,640
5,300 330 130 5,760
5,400 340 140 5,880
I hope this example helpful
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|