search case insensitive all duplicate records and print out
Thank you. Learned something new now as well.
On Wed, Mar 2, 2011 at 17:39, SCHROEDER, NATHAN E [AG/1000] <
firstname.lastname@example.org > wrote:
Wim - if the SELECT expression is a *function of* the GROUP BY expression(s), the query will run without an Oracle error. In this case it will probably not give the intended results, as you pointed out, but it will run. Nate Schroeder Enterprise Services - Data Management Team Monsanto Company 800 N. Lindbergh Blvd. LC4D - Saint Louis, MO - 63167 314-694-2592