DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: MIN() function

Hybrid View

  1. 05-02-2001, 10:26 AM #1
    farrokhp
    farrokhp is offline Senior Member
    Join Date
    Nov 2000
    Posts
    416
    when you put min() functions for a field does it mean that we have several occurance of that field but we need only one return ? How does it work internally?

    Reply With Quote Reply With Quote
  2. 05-02-2001, 11:35 AM #2
    sambavan
    sambavan is offline Senior Advisor
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Need some more time to research on this question. In the mean time thought that thos would help you to an extent.


    http://technet.oracle.com/doc/oracle...tio2.htm#81409


    Sam
    Thanx
    Sam



    Life is a journey, not a destination!

    Reply With Quote Reply With Quote
  3. 05-02-2001, 01:10 PM #3
    kmesser
    kmesser is offline Senior Member
    Join Date
    Aug 2000
    Posts
    462
    Yes it will give you the minimum value for that column across multiple rows.

    I think the link is:

    http://technet.oracle.com/doc/oracle...ti51.htm#84365
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width