|
|
select 商品コード
from 取引データ
where DatePart("m",取引日付) = 9
| |
|
|
select distinct 商品コード
from 取引データ
where DatePart("m",取引日付) = 9
| |
|
|
select count(*) as 9月売上商品種別数
from
( select distinct 商品コード
from 取引データ
where DatePart("m",取引日付) = 9
)
| |
|
|
|
|
select count(*) as [9月売上商品種別数]
from
(select distinct 商品コード
from 取引データ
where DatePart(m,取引日付) = 9) as 一時表
| |
|
|
select count(distinct 商品コード) as [9月売上商品種別数]
from 取引データ
where DatePart(m,取引日付) = 9
| |
|
|
|
|
select count(*) as `9月売上商品種別数`
from
(select distinct 商品コード
from 取引データ
where DATE_FORMAT(取引日付,'%m') = 9) as 一時表
| |
|
|
select count(distinct 商品コード) as `9月売上商品種別数`
from 取引データ
where DATE_FORMAT(取引日付,'%m') = 9
| |
|
|
|
|
select count(*) as "9月売上商品種別数"
from
(select distinct 商品コード
from 取引データ
where EXTRACT(MONTH from 取引日付) = 9) "一時表"
| |
|
|
select count(distinct 商品コード) as "9月売上商品種別数"
from 取引データ
where EXTRACT(MONTH from 取引日付) = 9
| |
|
|
|
|
select count(*) as "9月売上商品種別数"
from
(select distinct 商品コード
from 取引データ
where EXTRACT(MONTH from 取引日付) = 9) as "一時表"
| |
|
|
select count(distinct 商品コード) as "9月売上商品種別数"
from 取引データ
where EXTRACT(MONTH from 取引日付) = 9
| |
|
|
|