仅选择个别记录 [英] Select individual records only

问题描述

我有一张表格

custno, type, color
A1234, B, Red
A1234, C, Blue
A1277, B, Red
A1288, A, Black
A1288, B, Red
A1289, A, Black

我只需要检索只找到一次的唯一记录A1277和A1289。

I need to retrieve only the unique records A1277 and A1289 that are only found once.

推荐答案

这将在结果列表中显示 custNO

This will display the custNO on the result list,

SELECT  custNo
FROM    tableName
GROUP   BY custNO
HAVING  COUNT(*) = 1

但是如果你想获得整行，

but if you want to get the whole row,

SELECT  a.*
FROM    tableName a
        INNER JOIN
        (
            SELECT  custNo
            FROM    tableName
            GROUP   BY custNO
            HAVING  COUNT(*) = 1
        ) b ON a.custNo = b.custNo

• SQL小提琴演示（两个查询）



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