sql - 我的请求包含括号错误，但是没有

Question

编写此公式时出现错误（1- near"(":syntax error)，但我没有看到“（”丢失，提前感谢您的帮助。

select_last_tourn AS (
                SELECT fc.ID as FC_ID,fc.IDENTIFIANT, t.ID as TOUR_ID, t.DATE_TOURNEE,
                               max (t.DATE_TOURNEE) OVER (ORDER BY t.DATE_TOURNEE) DT_LAST_TOURNEE
                FROM RSF_FICHE_11 fc
                lEFT JOIN mnt ON fc.ID=mnt.ID1

标签： sqloracleqgis

Answer 1

如果您使用 CTE，请尝试以下操作：

WITH select_last_tourn AS (
                SELECT fc.ID as FC_ID,fc.IDENTIFIANT, mnt.ID as TOUR_ID, mnt.DATE_TOURNEE,
                max (mnt.DATE_TOURNEE) OVER (ORDER BY mnt.DATE_TOURNEE) DT_LAST_TOURNEE
                FROM RSF_FICHE_11 fc
                lEFT JOIN mnt ON fc.ID=mnt.ID1
                           )

SELECT * FROM select_last_tourn