※ 引述《yld (努力中!!)》之銘言：
: 不好意思請教一下
: 我是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不支援此種查詢呢
: 謝謝!!
我記得舊版MySQL不支援副查詢的方法
也就是說在Select裡面的來源不可以是從另一個select而來
而在MSSQL裡面這樣是允許的
但是從4.1版後已經可以正確的支援
下面位址讓妳參考一下
http://dev.mysql.com/doc/refman/5.0/en/subqueries.html
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 59.115.155.168