please suggest whether this table contains duplicate records

Hi,
The following table namely elcbtripselect [contains no primay key ]contains 5147 records.I want to know wether this table contains duplicate records or not.
I tried with following query
1)SELECT elcbtripselect.ELCBTRIP_voltsMIN, elcbtripselect.ELCBTRIP_voltsMAX, elcbtripselect.ELCBTrip_is_partwinding, elcbtripselect.ELCBTrip_is_ydelta, elcbtripselect.ELCBTRIP_starter_size, elcbtripselect.ELCBTRIP_UnitFunction, elcbtripselect.ELCBTRIP_strcb_speedi_frame_ty, elcbtripselect.ELCBTRIP_cb_style, elcbtripselect.ELCBTRIP_ol_relay_type, elcbtripselect.ELCBTRIP_fla_min, elcbtripselect.ELCBTRIP_fla_max, elcbtripselect.ELCBTrip_Speedi_ECM, elcbtripselect.ELCBTRIP_cb_trip
FROM elcbtripselect;
The result is 5147
Then by using Distinct
2)SELECT distinct elcbtripselect.ELCBTRIP_voltsMIN, elcbtripselect.ELCBTRIP_voltsMAX, elcbtripselect.ELCBTrip_is_partwinding, elcbtripselect.ELCBTrip_is_ydelta, elcbtripselect.ELCBTRIP_starter_size, elcbtripselect.ELCBTRIP_UnitFunction, elcbtripselect.ELCBTRIP_strcb_speedi_frame_ty, elcbtripselect.ELCBTRIP_cb_style, elcbtripselect.ELCBTRIP_ol_relay_type, elcbtripselect.ELCBTRIP_fla_min, elcbtripselect.ELCBTRIP_fla_max, elcbtripselect.ELCBTrip_Speedi_ECM, elcbtripselect.ELCBTRIP_cb_trip
FROM elcbtripselect;
The result is 5145
It means that it contains 2 duplicate records.
Now I executed following query to find duplicate records
3)SELECT elcbtripselect.ELCBTRIP_voltsMIN, elcbtripselect.ELCBTRIP_voltsMAX, elcbtripselect.ELCBTrip_is_partwinding, elcbtripselect.ELCBTrip_is_ydelta, elcbtripselect.ELCBTRIP_starter_size, elcbtripselect.ELCBTRIP_UnitFunction, elcbtripselect.ELCBTRIP_strcb_speedi_frame_ty, elcbtripselect.ELCBTRIP_cb_style, elcbtripselect.ELCBTRIP_ol_relay_type, elcbtripselect.ELCBTRIP_fla_min, elcbtripselect.ELCBTRIP_fla_max, elcbtripselect.ELCBTrip_Speedi_ECM, elcbtripselect.ELCBTRIP_cb_trip
FROM elcbtripselect
Group By elcbtripselect.ELCBTRIP_voltsMIN, elcbtripselect.ELCBTRIP_voltsMAX, elcbtripselect.ELCBTrip_is_partwinding, elcbtripselect.ELCBTrip_is_ydelta, elcbtripselect.ELCBTRIP_starter_size, elcbtripselect.ELCBTRIP_UnitFunction, elcbtripselect.ELCBTRIP_strcb_speedi_frame_ty, elcbtripselect.ELCBTRIP_cb_style, elcbtripselect.ELCBTRIP_ol_relay_type, elcbtripselect.ELCBTRIP_fla_min, elcbtripselect.ELCBTRIP_fla_max, elcbtripselect.ELCBTrip_Speedi_ECM, elcbtripselect.ELCBTRIP_cb_trip
having Count (*) >1
result: I got 2 records but they are having different values.
Please suggest me whether this table is having duplicate records or teel me wats the problem with this.
Herewith I have attached table[elcbtripselect] with 5147 records.

Thanks,
Nethra.

May 26 '07 #1

Subscribe Post Reply

2033

debasisdas

8,127

Expert 4TB

may i know please what is the database u r using, for my reference.

May 28 '07 #2

pbmods

5,821

Expert 4TB

result: I got 2 records but they are having different values.

Exactly. Those are your duplicate values.

May 29 '07 #3

by: maricel | last post by:

I have the following base table structure - DDL: CREATE TABLE "ADMINISTRATOR"."T1" ( "C1" INTEGER NOT NULL ) IN "TEST_TS" ; ALTER TABLE "ADMINISTRATOR"."T1" ADD PRIMARY KEY

DB2 Database

Query to delete duplicate records in staging table

by: ms | last post by:

Access 2000: I am trying to delete duplicate records imported to a staging table leaving one of the duplicates to be imported into the live table. A unique record is based on a composite key of 3...

Microsoft Access / VBA

Duplicate Records - Same Table - Multiple Criteria Fields - Please Help!

by: zeke | last post by:

Any assistance is much appreciated... I have a table with duplicate record information and I need to remove certain records based on values in four different fields. For example: PK field ...

Microsoft Access / VBA

Please help - Post Code Search

by: Steph | last post by:

Hi. I'm very new to MS Access and have been presented with an Access database of contacts by my employer. I am trying to redesign the main form of the database so that a button entitled...

Microsoft Access / VBA

c++ for data structures HELP SOLVE ASAP PLEASE

by: dtefran3 | last post by:

The problem Implement a SortedList class which stores a list of int data in ascending order. Program requirements The public interface of your class is as follows: class SortedList{ public:...

C / C++

Hepl please - Product stop to work on DB2 v9.1!

by: Dmitry Bond. | last post by:

Hello. Our product works fine on all 7.x and 8.x DB2 versions. But stops to work on DB2 v9.1. The main problem is - duplicate primary key (sqlcode=-803) happens when inserting records in...

DB2 Database

Please Help me Optimize my Code

by: TF | last post by:

Hello all, I made a ASP.NET 2.0 site that shows possible "recipes" for paint colors stored in an access dbase. Basically, 1000 colors are stored with specific RGB values in separate columns. A...

ASP.NET

How do I prevent records from being created in a related table?

by: jbrumbau | last post by:

Hello, I have been successfully using a database I've created for several months to populate an equipment list for a project we've been working on. However, the form has recently stopped working...

Microsoft Access / VBA

Querying a table with almost-duplicate records

by: billesque | last post by:

Hello! I was wondering if it's possible to take a table in Microsoft Access that contains duplicate records (though not exactly identical) and create queries for use in a form. The form, currently...

Microsoft Access / VBA

Easy Steps to Fix "Canon Printer Won't Connect to WiFi Network"

by: taylorcarr | last post by:

A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...

General

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

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,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

please suggest whether this table contains duplicate records

Similar topics