作者ami9897 (小新)
看板Database
标题[SQL ] 某公司的试题
时间Sun Feb 27 23:35:06 2011
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: 111.240.94.63
1F：推 bobju:用 group by 对 city 做分群,having 做筛选, count做计算. 02/28 02:36