Toad World® Forums

Search case insensitive all duplicate records and print out


#1

search case insensitive all duplicate records and print out


#2

Thank you. Learned something new now as well.

Groetjes,
Wim

On Wed, Mar 2, 2011 at 17:39, SCHROEDER, NATHAN E [AG/1000] <
nathan.e.schroeder@monsanto.com > 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