check for duplicate records in Command Window

[kenndot]

What's the quickest way to compare 2 tables and check for duplicate field values? I just need it in the command window not in the program.

Thanks.

 

[kenndot]

Okay, I'm sorry, I didn't mean that.

I have ONE table that I want to "read" and make sure there are no dups in a particular field within that table. I need to check the table quickly in the command window is all.

 

[EzLogic]

Hello, try that!

Select * from YourTable group by YourFieldToCheck having Count(*) > 1 Please let me know if this helped you

Tekno
Wireless Toyz
Ypsilanti, Michigan

 

[danceman]

select col1,col2,count(*);
from table;
group by col1,col2 having count(*) > 1

col1 and col2 represet the fields that you want to see if there are duplicates, this well could be one field.

the return result will should the duplicates. Attitude is Everything

 

[HotHand]

Here is what I use:

SELECT * FROM table1 WHERE col1 IN (SELECT col1 FROM table2)

any dups will show in cursor.