我要求一个查询,选择最新的100篇文章,然后返回该结果的30篇文章的最高评级排序。我的例子出了点问题。FROM SELECT articleid,articletitle,articleicon,timesviewed WHERE articlestatus = 1 AND (articletype = 1 || articletype = 6) )
ORDER BY (totalvotepoints/totalvotes)
select ((x.am1998-x.am1999)/ ((x.am1998+x.am1999)/2)) as answer from(sum(amount) FILTER(where EXTRACT(YEAR FROM order_date)=1999)) as am1999 from orders) x;
--------
我有3个表(provider、provider_has_product、product):
(原文:)SELECT DISTINCT `provider_has_product2行的Error Code: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQLsyntax to use near 'SELECT * FROMproductWHERE NOT EXIST