473,498 Members | 1,998 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL...duplicate data identification

4 New Member
Hello,
I'm attempting to identify duplicate store number (storeno) information from a customer table (custbuy) for a particular customer (custno), but am having difficulty doing so. Can anyone offer any insight.

Database Oracle 9i;
- No PRIMARY KEY

Column Data Type Null?
CUSTNO VARCHAR2 (7) N
STORENO VARCHAR2 (10) Y


Thanks,
JDM
Nov 27 '07 #1
3 1482
amitpatel66
2,367 Recognized Expert Top Contributor
Hello,
I'm attempting to identify duplicate store number (storeno) information from a customer table (custbuy) for a particular customer (custno), but am having difficulty doing so. Can anyone offer any insight.

Database Oracle 9i;
- No PRIMARY KEY

Column Data Type Null?
CUSTNO VARCHAR2 (7) N
STORENO VARCHAR2 (10) Y


Thanks,
JDM
Please POST what you tried to achieve this??
Nov 28 '07 #2
singhh04
4 New Member
This query will identify the duplicate (storeno) information from cust table for every customer.
Expand|Select|Wrap|Line Numbers
  1.  
  2. SELECT custno,storeno FROM customer GROUP BY custno,storeno HAVING COUNT(*)>1
  3.  
  4.  
Nov 29 '07 #3
amitpatel66
2,367 Recognized Expert Top Contributor
Hi Singhh04,

Please enclose your posted code in [code] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use [code] tags in future.

MODERATOR
Nov 29 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

7
2314
by: Lowell Kirsh | last post by:
I have a script which I use to find all duplicates of files within a given directory and all its subdirectories. It seems like it's longer than it needs to be but I can't figure out how to shorten...
18
27678
by: Elroyskimms | last post by:
I have a table using an identity column as its Primary Key and two columns (table reduced for simplicity) EmployeeNumber and ArrivalTime. CREATE TABLE ( IDENTITY (1, 1) NOT NULL , (10)...
2
1918
by: Pablo | last post by:
Hello, there, I have a table tblData which has pharmacy data. The table has following fields: ClaimNum, LineNum... The ClaimNum has claim number which is 12 characters. LineNum is NULL. The...
2
1549
by: Bernie Yaeger | last post by:
How do I get the data type of a given column of a datatable? Tx for any help. Bernie Yaeger
2
1636
by: suresh | last post by:
Hello to you all In my .Net application, I want to import document images (Tiff images), having same format, in a batch, For e.g. I have a document folder containing mixed images like...
5
3973
by: Manish | last post by:
The topic is related to MySQL database. Suppose a table "address" contains the following records ------------------------------------------------------- | name | address | phone |...
4
5838
by: FangQ | last post by:
hi I am very new to mysql. I have a question about using the "on duplicate update" clause with insert command. my table "data" has two columns, field1 and field2, where field1 is the index...
1
1713
by: oaklander | last post by:
I would like to make sure there are no duplicate data entries in my Oracle 9i table (called MainTable) which has an Id field that is the primary key, ValData with a varchar data type, Fid and Fid2...
2
7071
by: Yashgt | last post by:
Hi, We have a table of users with about 10000 rows. We have to import a large text file into this table. While doing so we would like to ensure that if a row already exists, it should not be...
0
7121
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7162
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7375
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5456
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4584
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3088
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3078
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
650
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
287
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.