我想要一个查询从 table2 中选择 4 个以上重复的 AccountId，并且在 table1 中具有不同的名称

发布于 2024-12-13 12:02:37 字数 522 浏览 0 评论 0原文

我希望查询从 table2 中选择 4 个以上的 AccountId 重复项，这些重复项在 table1 中具有不同的名称。

以下是表结构：

table1                             |       Table2
ID   AccountNumber  Name           |       ID       AccountNumber AccountID
1     12345         John Jeff      |        1          12345        A467T
1     12345         Patrick Jones  |        1          12345        A467T

ID 和 AccountNumber 是两个表上相同

Table1 具有名称
Table2 具有 AccountID

原文

I want a query to select more than 4 AccountId repetitions from table2 having distinct name in table1

Here are the table structures:

table1                             |       Table2
ID   AccountNumber  Name           |       ID       AccountNumber AccountID
1     12345         John Jeff      |        1          12345        A467T
1     12345         Patrick Jones  |        1          12345        A467T

ID and AccountNumber are the same on both tables

Table1 has Name
Table2 has AccountID

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

爱情眠于流年 2024-12-20 12:02:37

以下是查找具有 4 个以上不同名称的 AccountID 的查询：

select  t2.AccountID
from    Table1 as t1
join    Table2 as t2
on      t1.AccountNumber = t2.AccountNumber
        and t1.ID = t2.ID
group by
        t2.AccountID
having  count(distinct t1.Name) > 4

如果这不是您要查找的内容，请澄清问题！例如，您可以添加所需的输出。

编辑：在回复您的评论时，您可以使用子查询查询 ID 和号码：

select  distinct 
        ID
,       AccountNumber
,       AccoutnID
from    Table2
where   AccountNumber in 
        (
        ... place query from above here ...
        )

Here's a query to find AccountID's with more than 4 different names:

select  t2.AccountID
from    Table1 as t1
join    Table2 as t2
on      t1.AccountNumber = t2.AccountNumber
        and t1.ID = t2.ID
group by
        t2.AccountID
having  count(distinct t1.Name) > 4

If that's not what you were looking for, please clarify the question! For examole, you could add desired output.

EDIT: In reply to your comment, you could query the ID and Numbers with a subquery:

select  distinct 
        ID
,       AccountNumber
,       AccoutnID
from    Table2
where   AccountNumber in 
        (
        ... place query from above here ...
        )

回复收藏 0 原文

~没有更多了~