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?
Printable View
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?
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
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