问题描述
我有一个数据表,其中每一行都包含一个唯一的数字。为了重新排列数据并合并各行,我不得不删除这个唯一的数字并使用2个交叉表查询加入表。
I have a table of data where each row contains a unique number. In order to rearrange the data and merger various rows, I have had to remove this unique number and join the table with 2 crosstab queries.
但是,现在我需要带回至少一个唯一的号码。例如:
However, now I need to bring back at least one unique number. For example:
唯一编号 参考
付款类型 预期付款
实际付款
Unique Number ReferencePayment Type Expected PaymentActual Payment
12743234             3546575
DD 10
5
12743234 3546575DD 10 5
12743235 3546575
现金 20
15
12743235 3546575Cash 2015
我已根据参考将两条线合并在一起,现在我需要带回12743234或12743235.如果我是在excel中使用vlookup公式,它将返回第一个。这可以在sql中做吗?我试过Dlookup,但它没有
工作。
I have merged the two lines together based on the reference, now I need to bring back either 12743234 or 12743235. If I were to use a vlookup formula in excel, it would return the first one. Is this possible to do in sql? I tried Dlookup but it hasn't worked.
推荐答案
这篇关于功能类似于Access中的VLookup?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!