www.webdeveloper.com

Search:

Type: Posts; User: mawais31

Search: Search took 0.01 seconds.

  1. Replies
    11
    Views
    1,457

    thanks for your help! I got the point and since...

    thanks for your help! I got the point and since if we cannot represent the record with primary key then it would be difficult to join the table....

    Regards
    Awais khan
  2. Replies
    11
    Views
    1,457

    Thanks for your time, and help your query...

    Thanks for your time, and help

    your query give me following output,

    however I need
    mileage sum(amount)
    0 25134337
    1 40000
    2 500
  3. Replies
    11
    Views
    1,457

    yes it does... ID count(*) 0 2...

    yes it does...


    ID count(*)
    0 2
    639077 2
    1468482 2
    1564561 2
    1612265 2
    1688768 2
  4. Replies
    11
    Views
    1,457

    Well actually I want to get the frequency for...

    Well actually I want to get the frequency for mileage (category) variable vs invoice amount

    Simply saying that I want to sum all invoice amount with car mileage 0, 1, 2,3,4,5 and group them in...
  5. Replies
    11
    Views
    1,457

    Re:

    Well thanks for your quick feedback!

    I currently run

    SELECT c.mileage, SUM(amount)
    FROM claims c
    INNER JOIN invoice_info i
    ON i.ID = c.ID AND i.accident_date = c.accident_date
    GROUP BY...
  6. Replies
    11
    Views
    1,457

    Sql problems in large databases (Help)????

    I have a large database, Where I have two tables claims and invoices. In invoice table when I run the query

    select sum(amount) from invoices.
    Gives me value of 207859507

    However when I join...
Results 1 to 6 of 6
HTML5 Development Center



Recent Articles