RE: min function
- To: <bzelli@xxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 10 Mar 2006 14:42:06 -0500
It returns only one row, as do all aggregate functions.
=====================================
Jim Silverman
Senior Systems Database Administrator
Solucient, LLC
Telephone: 734-669-7641
FAX: 734-930-7611
E-Mail: jsilverman@xxxxxxxxxxxxx
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Friday, March 10, 2006 2:38 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: min function
Hello all,
A question that threw me the other day. Someone asked me if they use
the min function on a column, and that column has a duplicate value, how
many records will be returned? Will it only return one or will it
return all the equal low values?
Brian
--
//www.freelists.org/webpage/oracle-l
This message is a private communication. It may contain information that is
confidential
and legally protected from disclosure. If you are not an intended recipient,
please do
not read, copy or use this message or any attachments, and do not disclose them
to others.
Please notify the sender of the delivery error by replying to this message, and
then
delete it and any attachments from your system.
Thank you,
Solucient LLC
(eXclaimer 4x)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
