|
|
select
市区町村名,
count(*) as 件数
from 郵便番号マスタ
group by 市区町村名
having count(*) >= 100
order by count(*) desc
| |
|
|
|
|
select
市区町村名,
count(*) as 件数
from 郵便番号マスタ
group by 市区町村名
having count(*) >= 100
order by 件数 desc
| |
|
|
|
|
select
市区町村名,
count(*) as 件数
from 郵便番号マスタ
group by 市区町村名
having 件数 >= 100
order by 件数 desc
| |
|
|
|