a****y
发帖数: 91 | 1 外行问个问题：
想要设计个方法，精确得用来比较某天不同年份，保险总购买人数。数据结构如下：
Name Insurance Type Activity( enroll or drop) date premium
amount
Mike a E 1/1/2000 $300
Tom b D 1/8/2011 $200
Joe c E 3/2/2011 $150
谢谢！ | a*******8
发帖数: 2 | 2 select count(*) as total,
activity, date
from your_table
group by activity, date;
【在 a****y 的大作中提到】
: 外行问个问题：
: 想要设计个方法，精确得用来比较某天不同年份，保险总购买人数。数据结构如下：
: Name Insurance Type Activity( enroll or drop) date premium
: amount
: Mike a E 1/1/2000 $300
: Tom b D 1/8/2011 $200
: Joe c E 3/2/2011 $150
: 谢谢！
| w*r
发帖数: 2421 | 3 oracle sample
select extract(year from date) as ins_yr,
to_char(date ,'mmdd') as ins_dt,
count(*)
from table
group by extract(year from date),to_char(date ,'mmdd')
Teradata sample
select extract(year from "date") as ins_yr,
CAST(CAST("DATE" AS FORMAT 'MMDD') AS CHAR(4)) AS INS_DT,
COUNT(*)
FROM TABLE
GROU BY 1,2 | s**********o
发帖数: 14359 | 4 select
activity,
convert(datetime, convert (varchar, date,101)),
count(*) as total
from your_table
group by
activity,
convert(datetime, convert (varchar, date,101)) |
|
