Toad World® Forums

Multiple customer for same item

Hi ,

How do i find multiple customer for same item.

my table is like this

Cust Item

34 rrt

45 uut

55 rrt

65 nnt

Now my query should fetch only first and 3 rd row

Select * from table where item in (select item from table group by item having count(distinct cust)>1)

Nate Schroeder

US Row Crops IT Data Management Team

Monsanto Company

800 N. Lindbergh Blvd. G3WB - Saint Louis, MO - 63167

314-694-2592

From: winona [mailto:bounce-winona@toadworld.com]

Sent: Friday, September 05, 2014 11:52 AM

To: toadoracle@toadworld.com

Subject: [Toad for Oracle - Discussion Forum] Multiple customer for same item

Multiple customer for same item

Thread created by winona

Hi ,

How do i find multiple customer for same item.

my table is like this

Cust Item

34 rrt

45 uut

55 rrt

65 nnt

Now my query should fetch only first and 3 rd row

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


This e-mail message may contain privileged and/or confidential information, and is intended to be received only by persons entitled
to receive such information. If you have received this e-mail in error, please notify the sender immediately. Please delete it and
all attachments from any servers, hard drives or any other media. Other use of this e-mail by you is strictly prohibited.
All e-mails and attachments sent and received are subject to monitoring, reading and archival by Monsanto, including its
subsidiaries. The recipient of this e-mail is solely responsible for checking for the presence of "Viruses" or other "Malware".
Monsanto, along with its subsidiaries, accepts no liability for any damage caused by any such code transmitted by or accompanying
this e-mail or any attachment.
The information contained in this email may be subject to the export control laws and regulations of the United States, potentially
including but not limited to the Export Administration Regulations (EAR) and sanctions regulations issued by the U.S. Department of
Treasury, Office of Foreign Asset Controls (OFAC). As a recipient of this information you are obligated to comply with all
applicable U.S. export laws and regulations.

Thanks a lot ,

If i have give my item number in the query say “rrt” which will be from a file, how will i mention the item number in the query?

Select * from table where item in (select item from table group by item having count(distinct cust)>1) and rtt = :rtt_value

run from toad sql editor