oracle - Oracle:SQL未正确结束

Question

我试图在grails中运行此sql查询。 BUt获取SQL未正确结束的错误。

def sessionFactory    
final session = sessionFactory.currentSession;
final  String query  = 'select count(A.id) from Artifact as A LEFT JOIN classification as C on (A.id=C.artifact_id) where C.id IS NULL';
final sqlQuery = session.createSQLQuery(query);

def totalunclass =  sqlQuery.with {
                            addEntity(Artifact);                            
                            }

Answer 1

final  String query  = 'select count(A.id) as ct from Artifact A 
                       LEFT JOIN classification C on (A.id=C.artifact_id)
                        where C.id IS NULL';

Oracle只是不喜欢使用 AS关键字来别名表名称，因此将其删除。