获取重复的记录 [英] Get duplicate Records

问题描述

大家好，

我有两个表，其中一个表列类似

Hi all,

I have two tables one of the table columns like

tbl_emp
Id                        Total stops   Total Emp
100816080630010P   5                     6

tbl_Details
Id                        Stopnumbers   EmpId
100816080630010P     1     BACS136
100816080630010P     3     EmpHydTest118
100816080630010P     2     EmpHydTest13
100816080630010P     2     EmpHydTest19
100816080630010P     4     EmpHydTest52
100816080630010P     1     hdtest177

在tbl_trips上方的表格中，员工总数为6，而在tbl_tripdet中的empid计数为6，停止号不应这样重复，并且员工数应相同.如果计数小于或大于，则应获取这些详细信息.它应该像1,2,3,4,5,6.如果情况如上图所示，则停止号重复出现，那么我们应该获得这些记录.

我这样尝试过:

Form above tbl_trips total employees are 6 and in the tbl_tripdet empid count is 6 and stopnumbers should not repeat like this and employees count should be same. If the count is less than or grater than then those details should be get. It should be like 1,2,3,4,5,6. If the case is like as show above stopnumbers repeating then we should get those records.

I tried like this:

SELECT fld_tripid FROM tbl_trips tb
WHERE (fld_totalemps != (SELECT COUNT(fld_EMPID ) FROM tbl_tripdet
WHERE fld_tripid = tb.fld_tripid) OR
 ((tb.fld_TotalEmps * (tb.fld_TotalEmps+1))/2) !=
(SELECT SUM(fld_StopNumber) FROM tbl_tripdet
WHERE fld_tripid = tb.fld_tripid))
AND (SELECT COUNT(fld_EMPID) from tbl_TripDet where fld_TripID = tb.fld_TripID) >0

当我使用此查询时，需要花费一些时间.

谢谢&问候，
Jeevan.

When I used this query it''s taking time to run.

Thanks & Regards,
Jeevan.

推荐答案

SELECT COUNT(fld_EMPID)，* FROM tbl_tripdet
按COUNT(fld_EMPID)分组
具有COUNT(fld_EMPID)> 1


将会得到您的副本.
更多谷歌``通过SQL分组''

SELECT COUNT(fld_EMPID ), * FROM tbl_tripdet
group by COUNT(fld_EMPID )
Having COUNT(fld_EMPID ) > 1


that will get your duplicates.
for more; google ''group by having SQL''

这篇关于获取重复的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！