在某一列上获得DISTINCT有点模糊吗？ [英] A little fuzzy on getting DISTINCT on one column?

问题描述

我已经看到了该问题的几种不同版本，但是很难将其应用于我所需要的...

I've seen a few different versions of this question but having difficulty applying it to what I need...

MS SQL Server 2008查询：

MS SQL Server 2008 query:

SELECT Receipts.ReceiptID, Receipts.UserID, Receipts.UserCardID, FolderLink.ReceiptFolderLinkID
FROM dbo.tbl_ReceiptFolderLnk AS FolderLink 
    INNER JOIN dbo.tbl_Receipt AS Receipts ON FolderLink.ReceiptID = Receipts.ReceiptID

**

ReceiptID            UserID               UserCardID           ReceiptFolderLinkID
-------------------- -------------------- -------------------- --------------------
1                    1                    3                    2
2                    1                    3                    3
3                    1                    3                    10
4                    1                    4                    11
5                    1                    4                    13
6                    2                    5                    14
3                    1                    3                    15
4                    1                    4                    16

**

现在，我想在ReceiptID上获得不同的值。

Now I would like to get distinct values on ReceiptID. Using distinct will not work as distinct works on the entire row.

将不胜感激。

谢谢！

推荐答案

如果您希望原始查询中的所有结果列都希望每个ReceiptID只显示一次，那么您将需要使用GROUP BY。

If you want all the results columns in your original query and want each ReceiptID to only show up one time, you'll need to use GROUP BY.

就像：

SELECT Receipts.ReceiptID,
    MIN(Receipts.UserID),
    MIN(Receipts.UserCardID),
    MIN(FolderLink.ReceiptFolderLinkID)
FROM dbo.tbl_ReceiptFolderLnk AS FolderLink
INNER JOIN dbo.tbl_Receipt AS Receipts ON FolderLink.ReceiptID = Receipts.ReceiptID
GROUP BY Receipts.ReceiptID

这篇关于在某一列上获得DISTINCT有点模糊吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！