| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: min function
It returns only one row, as do all aggregate functions.
FAX: 734-930-7611 E-Mail: jsilverman_at_solucient.com
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Friday, March 10, 2006 2:38 PM
To: oracle-l_at_freelists.org
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
--
http://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)
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 10 2006 - 13:42:06 CST
 |
 |