Results 1 to 3 of 3

Thread: create row and calculate column

  1. #1
    Join Date
    Oct 2009
    Posts
    1

    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.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    What's the result you like to see?

  3. #3
    Join Date
    Nov 2009
    Posts
    1
    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
  •