下面是在oracle上工作但不使用PostgreSQL的Sql查询。select count(*) from users where id>1 order by username;ERROR: column "users.username" must appear in the GROUP BY clause or be used i
我习惯于在Oracle数据库上运行,所以我真的不太确定如何解决这个问题。我已经将我的查询的一个简单示例缩小到以下范围:'-ALL Grantmakers-' as grantmakerName GROUPcorresponds to your MySQL server version for the right syntax to use near 'ORDER BY 2 LIMIT 0, 30'