Question

SQL报缺少右括号是什么问题？帮忙看下语句

Select f1_0019,f2_0019
From tb_object_0019
Where (F3_0019 = '115200000')
GROUP By f1_0019,f2_0019 DESC
Having Count(f1_0019)>1

Answer 1

去掉desc关键字

Answer 2

GROUP By f1_0019, f2_0019 DESC这句出问题了吧，只有order by desc，没有group by desc

Answer 3

GROUP By f1_0019,f2_0019 DESC

把DESC 去掉

Answer 4

where那里应该不要括号 试试看