如何从原始表中获取记录号 [英] How to get record number from original table

问题描述

嗨


如何从原始表中获取行号？我们做了一个

查询并得到一个结果。结果中的行号与结果源表中的rownumber不同

。我需要原始表格中的

记录号。你怎么得到这个号码？


请帮助，


问候，马丁

Hi

Any idea on how to get a row number from the original table? We do a
query and get a result. The row number from the result is different
from the rownumber of the table the result originated from. I need the
record number from the original tabel. How do you get THAT number?

Please help,

Regards, Martin

推荐答案

Martin Heuckeroth< ni ** @ nospam.invalid>写在

新闻：ot ******************************** @ 4ax.com：

Martin Heuckeroth <ni**@nospam.invalid> wrote in
news:ot********************************@4ax.com:

关于如何从原始表中获取行号的任何想法？我们做了一个
查询并得到了一个结果。结果中的行号与结果源自的表的rownumber不同。我需要原始表格中的
记录号码。你怎么得到这个号码？

Any idea on how to get a row number from the original table? We do a
query and get a result. The row number from the result is different
from the rownumber of the table the result originated from. I need the
record number from the original tabel. How do you get THAT number?

你做了一个SELECT COUNT（*）吗？或者你做了一个SELECT COUNT（FIELDNAME）？如果

你做了第二次，它会返回非空值，这可能就是为什么你的行

计数是不准确的：

http://msdn.microsoft.com/library/de .. .l = / library / en-

us / tsqlref / ts_ca-co_5790.asp


-

Lucas Tam（RE********@rogers.com）

请删除删除来自回复时的电子邮件地址。
http：//成员。 ebay.com/aboutme/coolspot18/

你想做什么？


其中一个基本的关系数据库的规则是行的顺序

并不重要。如果你需要识别一个特定的行，你应该使用

键和唯一索引。


hth

Richard

What are you trying to do?

One of the basic rules of relational databases is that the order of rows is
not important. If you need to identify a particular row you should be using
keys and unique indexes.

hth
Richard

我认为Martin正在寻找类似于RowIndex的六十进制值

在Oracle中可用的东西。您是否尝试删除错误创建的重复行

？你在做什么？如果你试图删除重复行我

有查询可以做到这一点..让我知道....但如果你想在程序I中使用
我不知道...


VJ


" Martin Heuckeroth" < NI ** @ nospam.invalid>在消息中写道

新闻：ot ******************************** @ 4ax.com ...

I think Martin is looking for something like RowIndex the hexadecimal value
that is available in Oracle. Are you trying to delete duplicate rows created
by mistake? what are you trying do ? If you are trying to delete dup rows i
have queries that can do that.. let me know .... but if you are looking to
use in program I am not aware of it...

VJ

"Martin Heuckeroth" <ni**@nospam.invalid> wrote in message
news:ot********************************@4ax.com...

您好

如何从原始表中获取行号？我们做了一个
查询并得到了一个结果。结果中的行号与结果源自的表的rownumber不同。我需要原始表格中的
记录号码。你怎么得到这个号码？

请帮忙，

问候，马丁

Hi

Any idea on how to get a row number from the original table? We do a
query and get a result. The row number from the result is different
from the rownumber of the table the result originated from. I need the
record number from the original tabel. How do you get THAT number?

Please help,

Regards, Martin

这篇关于如何从原始表中获取记录号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！