sql - 关键字 'ORDER' 附近的语法不正确

Question

我的应用程序正在生成这个查询。有人能告诉我这个查询有什么问题吗

     SELECT task_id, 
     Count(*) Unread 
     FROM   discussion 
     WHERE  NOT EXISTS (SELECT * 
                        FROM   discussion_read 
                        WHERE  discussion.discussion_id = 
                        discussion_read.discussion_id 
                        AND discussion_read.user_id = ? 
                        AND discussion.task_id IN 
                          ((SELECT TOP 1025 task.task_id 
                            FROM   task 
                            WHERE 
                          ( ( task.task_code = 'A3090' ) 
                            AND ( task.proj_id = 6511 ) )) 
                                                 ORDER  BY task.task_id ASC) 
              ) 
    GROUP  BY task_id 

Answer 1

你的订单需要在 ) 下面试试

SELECT task_id, 
 Count(*) Unread 
 FROM   discussion 
 WHERE  NOT EXISTS (SELECT * 
                    FROM   discussion_read 
                    WHERE  discussion.discussion_id = 
                    discussion_read.discussion_id 
                    AND discussion_read.user_id = ? 
                    AND discussion.task_id IN 
                      ((SELECT TOP 1025 task.task_id 
                        FROM   task 
                        WHERE 
                      ( ( task.task_code = 'A3090' ) 
                        AND ( task.proj_id = 6511 ) ) 
                                             ORDER  BY task.task_id ASC)) 
          ) 
GROUP  BY task_id