将sql查询转换为msaccess [英] Convert sql query into msaccess

问题描述

select logstep,logdate,min(MinOflogTime),max(MaxOflogTime) from
(
    SELECT l.logStep,l.LOGDATE,Min(l.logTime) AS MinOflogTime, Max(l.logTime) AS MaxOflogTime
    FROM TBLLOG9800 l
    GROUP BY l.logStep,l.LOGDATE
    ORDER BY l.logStep
) 
group by logstep, logdate
ORDER BY logStep;

推荐答案

您不能在子目录中使用 ORDER BY 子句查询。删除/注释内部查询中的ORDER BY子句。但是你可以使用 ORDER BY 和 SELECT TOP .. 。

You can not use ORDER BY clause in a sub-query. Remove/comment the ORDER BY clause in the inner query. However you can use ORDER BY along with SELECT TOP.. though.

select logstep,logdate,min(MinOflogTime),max(MaxOflogTime) from
(
    SELECT l.logStep,l.LOGDATE,Min(l.logTime) AS MinOflogTime, Max(l.logTime) AS MaxOflogTime
    FROM TBLLOG9800 l
    GROUP BY l.logStep,l.LOGDATE
    --ORDER BY l.logStep
) 
group by logstep, logdate
ORDER BY logStep;

希望，它有帮助：）

Hope, it helps :)

那里无需转换！



在您的情况下，外部 SELECT 语句是无用的。

There's nothing to convert!

In your case, external SELECT statement is useless.

SELECT l.logStep, l.LOGDATE, Min(l.logTime) AS MinOflogTime, Max(l.logTime) AS MaxOflogTime
FROM TBLLOG9800 AS l
GROUP BY l.logStep, l.LOGDATE
ORDER BY l.logStep

详情请见：

访问中查询的提示和技巧 [ ^ ]

SQL子查询（Microsoft Access SQL） [ ^ ]

这篇关于将sql查询转换为msaccess的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！