Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Getting Duplicate Records

3 Posts 3 Posters 0 Views 1 Watching

R Offline
R Offline
Ramuv

wrote on last edited by

#1

hi, how can i query duplicate records from a ms access table.

ram
N K 2 Replies Last reply

0
R Ramuv

hi, how can i query duplicate records from a ms access table.

ram
N Offline
N Offline
Navneet Hegde

wrote on last edited by

#2

How are you going to enter duplicate records

Develop2Program & Program2Develop
1 Reply Last reply

0
R Ramuv

hi, how can i query duplicate records from a ms access table.

ram
K Offline
K Offline
Krish KP

wrote on last edited by

#3

for example tblA col1 col2 101 AAA 102 BBB 101 AAA 103 CCC 103 CCC select col1, col2 from tblA gorup by col1, col2 having count(*) > 1 returns all rows which are repeated

Regards KP
1 Reply Last reply

0

Log in to reply