→ zephyrhymn:靠唄~~~怎麼那麼像某大學碩班的考古題(指答案)XD!!! 03/01 21:48
→ bobju:這種答案,會的人大概都是這麼寫的.這題難度算低了. :( 03/02 11:59
結構是這樣:
select city,count(*)
from Customer
group by city having count(*) >= 6
※ 引述《ami9897 (小新)》之銘言：
: Below is the customer table in database ABC.
: [Customer Table]:
: ID Name Salary City
: ====================================
: 1 Romeo 1000 Surabaya
: 2 Julia 3000 Ho chi min
: 3 Robert 2000 Hongkong
: ?
: 100 Deniro 5000 Singapore
: (total record = 100)
: (Id is Primary Key)
: Please provide a SQL script to query customer that his/her city occurs in
: the table more than or equal to 6.
: Example:
: The number of customer that live in hongkong is 10
: The number of customer that live in surabaya=5
: The number of customer that live in singapore=6.
: So in this example the output should be all customer that live in
: Singapore and Hongkong only.
: 到現在小弟還想不出來 不知版上大大是不是有想法
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 115.43.11.116