sql - postgresql语法错误？

Question

我无法识别此查询的语法错误，语法错误在哪里？

select c_name, c_address, c_mktsegment , count(*) as cnt customer join orders on c_custkey=o_custkey 
where
(c_name like %r% AND c_address like %a%) OR c_mktsegment like ='%t%'   
group by c_name, c_address, c_mktsegment having count(*)>2;

Answer 1

一个错误是您在此处缺少引号:

(c_name like %r% AND c_address like %a%)

应该是:

(c_name like '%r%' AND c_address like '%a%')

---

评论中提到的另一个问题是你错过了 FROM 关键字:

select c_name, c_address, c_mktsegment , count(*) as cnt customer 

应该是:

SELECT c_name, c_address, c_mktsegment , count(*) as cnt
FROM customer 

---

可能还有其他错误。但是您可以确定这两个问题都是实际上是问题并且它们确实需要修复。我强烈建议您先修复它们，然后再进一步调查任何其他问题。