电源查询 - 如何限制从进度数据库中提取的行

发布于 2025-01-28 22:14:24 字数 510 浏览 1 评论 0原文

我与odbc的进步openhedge dadabase相连。我想限制提取的记录数量，但我无法确定将SQL代码放在哪里。示例代码读取如下：

Source = Odbc.DataSource("dsn=ODBCMXP", [HierarchicalNavigation=true]),
abcd_Database = Source{[Name="abcd",Kind="Database"]}[Data],
PUB_Schema = abcd_Database{[Name="PUB",Kind="Schema"]}[Data],
#"invoice-line_Table" = PUB_Schema{[Name="invoice-line",Kind="Table"]}[Data],

我想将记录限制为DocumentNumber＆gt;例如10000或Document Date＆gt;例如，“ 2022-01-01”。在其他表格上读取数百万行并需要过滤后需要过滤并增加更新时间的其他表上也出现了同样的问题。可以批准有关查询代码的帮助！

原文

I am connected to a Progress OpenHedge Dadabase though ODBC. I want to limit the number of records extracted but I cannot figure where to put the sql code.
sample code reads as follows:

Source = Odbc.DataSource("dsn=ODBCMXP", [HierarchicalNavigation=true]),
abcd_Database = Source{[Name="abcd",Kind="Database"]}[Data],
PUB_Schema = abcd_Database{[Name="PUB",Kind="Schema"]}[Data],
#"invoice-line_Table" = PUB_Schema{[Name="invoice-line",Kind="Table"]}[Data],

I would like to limit records to Documentnumber > 10000 for example or DocumentDate > "2022-01-01" for example.. the same problems arise on other tables where millions of rows are read and need to be filtered out after and thus increasing update time.
Help with the query code would be appraciated !

分享到QQ

分享到微博