Professional Web Applications Themes

Query to Find Difference in Greatest and Least Values in Field - MySQL

Hi -- I need to find the highest and lowest entries in a field, and calculate the difference. Can I do this with one query (mysql 4.0.2)? I'm just getting back into php/mysql after a year's absence, so I'm sorry if this is a basic question. I'm sure something simple is escaping me -- and will come to me as soon as this hits the server. Googled into the wee hours with no success. Thanks for any help -- Blue...

  1. #1

    Default Query to Find Difference in Greatest and Least Values in Field

    Hi --

    I need to find the highest and lowest entries in a field, and calculate
    the difference. Can I do this with one query (mysql 4.0.2)?

    I'm just getting back into php/mysql after a year's absence, so I'm sorry
    if this is a basic question. I'm sure something simple is escaping me --
    and will come to me as soon as this hits the server. Googled into the wee
    hours with no success.

    Thanks for any help --

    Blue
    BlueBrooke Guest

  2. #2

    Default Re: Query to Find Difference in Greatest and Least Values in Field


    BlueBrooke wrote:
    > Hi --
    >
    > I need to find the highest and lowest entries in a field, and calculate
    > the difference. Can I do this with one query (mysql 4.0.2)?
    >
    > I'm just getting back into php/mysql after a year's absence, so I'm sorry
    > if this is a basic question. I'm sure something simple is escaping me --
    > and will come to me as soon as this hits the server. Googled into the wee
    > hours with no success.
    >
    > Thanks for any help --
    >
    > Blue
    so what have you got so far?

    SELECT max( fieldname ) - min( fieldname )
    FROM table

    strawberry Guest

  3. #3

    Default Re: Query to Find Difference in Greatest and Least Values in Field

    On Sat, 05 Aug 2006 11:11:59 -0500, strawberry <zac.carey> wrote:
    >
    > BlueBrooke wrote:
    >> Hi --
    >>
    >> I need to find the highest and lowest entries in a field, and calculate
    >> the difference. Can I do this with one query (mysql 4.0.2)?
    >>
    >> I'm just getting back into php/mysql after a year's absence, so I'm
    >> sorry
    >> if this is a basic question. I'm sure something simple is escaping me
    >> --
    >> and will come to me as soon as this hits the server. Googled into the
    >> wee
    >> hours with no success.
    >>
    >> Thanks for any help --
    >>
    >> Blue
    >
    > so what have you got so far?
    >
    > SELECT max( fieldname ) - min( fieldname )
    > FROM table
    I had tried that, but it didn't return the value I thought it should.
    There must have been another problem with it, as it's working now --

    Thank you so much --

    Blue
    BlueBrooke Guest

Similar Threads

  1. Getting values from a field in a pdf
    By CasparNielsen@adobeforums.com in forum Adobe Acrobat SDK
    Replies: 28
    Last Post: December 13th, 07:24 AM
  2. #39723 [NEW]: eregi in difference query
    By toomore0929 at gmail dot com in forum PHP Bugs
    Replies: 1
    Last Post: December 4th, 10:53 AM
  3. How to find a dataset had values
    By Gomathi in forum ASP.NET Data Grid Control
    Replies: 2
    Last Post: November 16th, 05:37 AM
  4. Calculated Field in Query of Query
    By madeiras in forum Coldfusion Database Access
    Replies: 0
    Last Post: July 14th, 11:52 PM
  5. Convert a query to a list, or find an item in a query
    By Laverda668 in forum Macromedia ColdFusion
    Replies: 2
    Last Post: April 7th, 07:41 PM

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