Functions - MAX()

Results 1 to 3 of 3

Thread: Functions - MAX()

  1. #1
    Join Date
    Dec 1969

    Default Functions - MAX()

    SELECT MAX(Age) FROM Persons<BR><BR>That should find the max age, eh? But I don&#039;t understand where it returns the result... I&#039;ve tried saving that all in a string and then running RS.Open = cnn.execute(SQL), but I still don&#039;t know where to get the return value (the max age in this case). Can someone help me out (this should be simple, I think).

  2. #2
    Join Date
    Dec 1969

    Default RE: Functions - MAX()

    Select Max(Age) As MaxAge from Persons<BR><BR>RS("MaxAge")<BR><BR>hope that helps!<BR><BR>Jason<BR>

  3. #3
    Kris yo Guest

    Default RE: Functions - MAX()

    Indeed it did. I did not have that As portion in there, but it works all good now.

Posting Permissions

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