从单行获取不同的值 [英] Getting Distinct Values From A Single Row

问题描述

我正在尝试删除任何重复的值，并使用下面的选择查询显示唯一值。我需要select查询只显示基于Member.ID的不同值

I am trying to remove any duplicate value and display just the unique values using the select query below. I need the select query to display just the distinct values based on Member.ID

展开 | 选择 | Wrap | 行号

推荐答案

你可能想要第一行中的 SELECT DISTINCT 。


如果这不是您想要的，那么您需要更清楚地提出问题，因为这不是没有多大意义。

You probably want SELECT DISTINCT in line one.

If that''s not what you want, then you need to ask the question more clearly, as this doesn''t make much sense.

我在最初启动查询时尝试使用Select Distinct，但它没有提供我追求的独特记录。


基本上我想要的是什么实现是;从成员表中检索列出的行但在要检索的列表中仅根据Member.ID选择不同的记录（当您根据某列删除或删除重复记录时，类似于excel中的类似）。 Member.ID可能与多个记录相关联，但我想摆脱重复并只显示member.id行的一个唯一记录。


我希望我的解释有意义??

I tried it with Select Distinct when I initially started the query but it does not provide the unique records I am after.

Basically what I am trying to achieve is; from the member table retrieve the rows listed but in the list being retrieved select only the distinct records based on the Member.ID ( kind of like in excel when you remove or delete duplicate records based on a certain column). The Member.ID may be associated with multiple records but I want to get rid of the duplication and display just one unique record of the member.id row.

I hope my explaination makes sense??

如果Member.ID与多条记录相关联，那么它如何显示一条唯一记录，因为某些字段会有多个值，当然呢？除非我遗漏了一些令人目眩的明显......

If Member.ID is associated with multiple records then how can it display one unique record as some of the fields will have multiple values, surely? Unless I''m missing something blindingly obvious...

这篇关于从单行获取不同的值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！