在PowerBI桌面中使用Order查询SQL数据库时出错

Question

在使用Get数据与PowerBI桌面连接到SQL数据库时获取此错误

Microsoft : ORDER子句在视图、内联函数、派生表、子查询和公共表表达式中无效，除非还指定了TOP、偏移量或用于XML。

SELECT PromotionID, PromoDescription, PromoStartDate, 
    CASE
        WHEN PromoDescription LIKE '%QUINELLA%' OR
             PromoDescription LIKE '%EXACTA%' OR
             PromoDescription LIKE '%TRIFECTA%' OR
             PromoDescription LIKE '%FIRST FOUR%' THEN 1
        ELSE 0
    END [Priority]
FROM TBS.dbo.Promotion WITH (NOLOCK) 
WHERE ArchivePartition IN (0,1)
  AND PromoDescription NOT LIKE '%QUINELLA%' 
  AND PromoDescription NOT LIKE '%EXACTA%' 
  AND PromoDescription NOT LIKE '%TRIFECTA%' 
  AND PromoDescription NOT LIKE '%FIRST FOUR%'

--AND PromoEndDate > getdate()-90
ORDER BY Priority ASC, PromoStartDate DESC'''

我看到我可以把上面的部分改为顶级的XXXXX。

SELECT Top 1000 PromotionID, PromoDescription, PromoStartDate

如何在不使用此黑客的情况下返回所有结果？

Answer 1

也许这能给你想要的结果

ORDER BY Priority ASC, PromoStartDate DESC OFFSET 0 ROWS