Professional Web Applications Themes

subcontraction - Microsoft SQL / MS SQL Server

I have the following table tbl1 ID Amount 1 10 2 5 I want to write a query the returns the following result set: Amount_Difference 5 How do I do this? I would greatly appreciate the help! Thanks. Derek...

  1. #1

    Default subcontraction

    I have the following table

    tbl1

    ID Amount
    1 10
    2 5

    I want to write a query the returns the following result
    set:

    Amount_Difference
    5

    How do I do this?

    I would greatly appreciate the help!

    Thanks.

    Derek
    Derek Guest

  2. #2

    Default Re: subcontraction

    Derek,

    If your table contains only two rows, and the IDs are 1 and 2,
    a solution is

    select (
    select Amount from tbl1 where ID = 1
    ) - (
    select Amount from tbl1 where ID = 1
    ) as Amount_Difference

    If you are looking for a general solution that returns some kind
    of differences in a larger table or for arbitrary ID values, it would
    help if you give an example table with more rows and the result
    you want for that table.

    -- Steve Kass
    -- Drew University
    -- Ref: 066C1660-21A6-463C-91C3-82EA7DCCFC56

    Derek Ruesch wrote:
     

    Steve Guest

  3. #3

    Default Re: subcontraction

    Here is another way.

    select
    (select amount from tbl1 where [ID] = 1)
    -
    (select amount from tbl1 where [ID] = 2)


    Here is something that gives more answers.
    select
    tbl1a.[ID],
    tbl1b.[ID],
    tbl1a.[Amount] - tbl1b.[Amount] as Amount_Difference
    from tbl1 tbl1a cross join tbl1 tbl1b
    order by tbl1a.[ID],tbl1b.[ID]

    Bye,
    Delbert Glass



    "Delbert Glass" <com> wrote in message
    news:phx.gbl... 
    >
    >[/ref]


    Delbert Guest

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139