将MySQL查询转换为SQL Server(MSSQL/SQLSRV)(完全不同) [英] CONVERT MySQL Query to SQL Server (MSSQL / SQLSRV) (WiTH DISTINCT)

问题描述

我需要怎么做才能将该查询转换为可在SQL Server中使用?

What do I need to do to convert this query to work within in SQL Server?

SELECT 
    DISTINCT(map_objetivos.OBJ_RowID) AS test,
    map_objetivos.OBJ_Objetivo
FROM 
    map_admin_caminho_critico_indicadores
INNER JOIN 
    map_admin_caminho_critico ON CCR_RowID = CCI_CaminhoDR
INNER JOIN 
    map_indicadores ON IND_RowID = CCI_IndicadorDR 
INNER JOIN
    map_objetivos ON OBJ_RowID = IND_ObjetivoDR
GROUP BY
    map_objetivos.OBJ_RowID

推荐答案

与MySQL不同，SQL Server不允许选择列表中未聚合或分组的字段.另外，您的DISTINCT是多余的.试试这个:

SQL Server, unlike MySQL, won't allow unaggregated or grouped fields in the select list. Also, your DISTINCT is redundant. Try this:

SELECT 
    map_objetivos.OBJ_RowID AS test,
    map_objetivos.OBJ_Objetivo
FROM 
    map_admin_caminho_critico_indicadores
INNER JOIN 
    map_admin_caminho_critico ON CCR_RowID = CCI_CaminhoDR
INNER JOIN 
    map_indicadores ON IND_RowID = CCI_IndicadorDR 
INNER JOIN
    map_objetivos ON OBJ_RowID = IND_ObjetivoDR
GROUP BY
    map_objetivos.OBJ_RowID,
    map_objetivos.OBJ_Objetivo

这篇关于将MySQL查询转换为SQL Server(MSSQL/SQLSRV)(完全不同)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！