Duplicate Records

Delete duplicate values in Microsoft Access

there was a ms access database in which there 3 to 4 values same so i want to delete the values keeping only one value. so i need a query.

Single Page subfile for duplicate records

Can you please tell me the how to handle the pageup & pagedown in single page subfile ....(In Physical file keyfield have douplicate records e.g. Douplicate Policy Number )

Microsoft Excel - I need to find rows that match a user entered entries and sum results of column b

I have a spread sheet that looks like this Project Well Hours Lewis 1 12 Lewis 2 3 Lewis 1 9 I want to find all the rows that match a user inputed name (in this case 'Lewis'), then add the numbers in column c labeled 'hours', if the sum equals 24 then no problem,...

AS/400 QADBIFLD error Duplicate Record Key?

The AS400 job QDBSRVXR2 has system error message Duplicate Record in QADBIFLD. I am aware this is a system cross reference file. (System is doing an automatic reply of C and then tries again) Is this file now corrupt ? Would an IPL help ? Reclaim Storage ? What is causing this error. (System is...

How to get the duplicate records using RPG/400

Please advice how to get the duplicate records using rpg/400.

Duplicating records in a table with a SQL query

How can I duplicate every record in a table with a query in SQL?

Crystal Reports - Duplicating labels

I need to print x number of labels from a table labels. The field numlabel specifies the number of labels I should print for each record. I tried with an alias and the != join.. but not working properly. Is there a way to duplicate records on crystal reports with functions or.. ?

RPG 3 duplicate record error handler

The physical file has a field keyed and unique. If i want to update these to RPG 3 program it is showing a duplicate record error. Does anybody have solution? tell me the command to handle this error only for RPG 3.

Fastest "get duplicates" SQL

What is an example of a fast SQL to get duplicates in datasets with hundreds of thousands of records. I typically use something like: select afield1, afield2 from afile a where 1 < (select count(afield1) from afile b where a.afield1 = b.afield1);

Help finding duplicate info in Excel in different columns

Hi, I have an excel spreadsheet that looks like below: Origin Store1 Store2 Percent Source Warren 12345 45678 2.45 b Warren 45678 12345 2.45 r I want to be able to recognize and delete one of these rows as a...

SQL

I have some duplicate rows in my SQL database table, Please Tell me how'll delete duplicate