[請益] SQL語法=>使用My SQL
不好意思請教一下
我是My SQL的新手，這問題已經困擾我很久了
select temp.week_ending,temp.total_sold
from
(select week_ending,sum(units_sold) as total_sold
from sold
group by week_ending) as temp
where temp.total_sold =
(select max(total_sold)
from
(select week_ending,sum(units_sold) as total_sold
from sold
group by week_ending) as temp2
)
以上的語法我用於ACCESS與SQL Server中皆可以RUN
但是用在MY SQL中就不能RUN了會出現下列字句
You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version
for the right syntax to use near
'select week_ending,sum(units_sold) as total_sold from
想請問一下是版本問題還是My SQL不支援此種查詢呢
謝謝!!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 163.22.32.128
推
10/18 21:17, , 1F
10/18 21:17, 1F
→
10/19 09:25, , 2F
10/19 09:25, 2F
討論串 (同標題文章)
以下文章回應了本文：
完整討論串 (本文為第 1 之 2 篇)：
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
125
129