在表中查找重复值 [英] find duplicate value in table

问题描述

你好每一个

i我试图在我的选民表中罚款重复值

我想要找到重复的姓名和地址。





表名和houseno是两列我想显示相同的数据



if



姓名Houseno



sand k123



komal h123



sand k123



如果这是表格中的数据



i希望显示如下这个



名字houseno

sand k123

sandy k123



请帮帮我。



提前谢谢。

解决方案

您好，您可以使用带有Group和Having子句的语句来查找重复项：

 选择名称，计数（名称） as  Cnt 来自选民
 组  by 名称
  计数（名称）>  1  

MS Access有一个内置的查询构建器向导，用于查找重复项



query-wizard.html [ ^ ]

复制（它意味着cretae另一个表并从anothor表中移动数据）你的表值并导入另一个表在Import表中删除所有不同的值，你得到重复值

hello every one
i am trying to fine the duplicate value in my voter table
where i want find duplicate name and address.


in table name and houseno are two column i want display the data which are same where

if

Name Houseno

sandy k123

komal h123

sandy k123

if this is the data in table

i want display the like this

name houseno
sandy k123
sandy k123

please help me.

thanks in advance.

解决方案

Hi, you can use a statement with Group and Having clause to find duplicates:

Select Name, Count(Name) as Cnt from voters
Group by Name
Having Count(Name) > 1

MS Access has a built-in query builder wizard for finding duplicates

query-wizard.html[^]

Copy(it mean cretae another table and move the data from anothor table) your table value and import another table in Import table delete all the distinct value and you to get duplicate value

这篇关于在表中查找重复值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！