计数sql

CREATE DATABASE [person] ON (NAME = N'goods_data', FILENAME = N'C:\goods_Data.MDF' , SIZE = 2, FILEGROWTH = 10%), (NAME = N'goods_data1', FILENAME = N'D:\goods_Data1.NDF' , SIZE = 1, FILEGROWTH = 2), (NAME = N'goods_data2', FILENAME = N'D:\goods_data2.NDF' , SIZE = 1, FILEGROWTH = 2) LOG ON (NAME = N'goods_log', FILENAME = N'E:\goods_log.LDF' , SIZE = 3, FILEGROWTH = 1)

用关键字查询,统计

oracle:

select to_char(date,'yyyy-mm-dd'御樱氏颂仿),count(*) from td group by to_char(date,'镇散yyyy-mm-dd')

在实验室，晚上回去有空就做了玩玩哈

是指那一周一共有多少条记录的话
表应该有id吧
select count(id) from 表名 between 起始日期 and 最终日期
是这个意思么....

SELECT ID,ACCOUNT,COUNT(*) FROM XXX INNER JOIN XXX
GROUP BY ID,ACCOUNT

select x.class 班级,count(y.num) 发稿数量
from myuser x,zgtx y where x.class=y.class group by x.class;

select aid , (a收入+c.b收入+d.b收入)/3 as 平均收入 from a , (select aid,b收入 from b where 关系=' 配偶' ) as c,(select aid,b收入 from b where 关系=' 子女' ) as d
where a.aid = c.aid
and c.aid = d.aid

select
substrb(create_time,1,4)
"年份",
sum(decode(substrb(create_time,6,2),'01',commission,0))
"1月",
sum(decode(substrb(create_time,6,2),'02',commission,0))
"2月",
sum(decode(substrb(create_time,6,2),'03',commission,0))
"3月",
sum(decode(substrb(create_time,6,2),'04',commission,0))
"4月",
sum(decode(substrb(create_time,6,2),'05',commission,0))
"5月",
sum(decode(substrb(create_time,6,2),'06',commission,0))
"6月",
sum(decode(substrb(create_time,6,2),'07',commission,0))
"7月",
sum(decode(substrb(create_time,6,2),'08',commission,0))
"8月",
sum(decode(substrb(create_time,6,2),'09',commission,0))
"9月",
sum(decode(substrb(create_time,6,2),'10',commission,0))
"10月",
sum(decode(substrb(create_time,6,2),'11',commission,0))
"11月",
sum(decode(substrb(create_time,6,2),'12',commission,0))
"12月"
from
test
group
by
substrb(create_time,1,4)
此语句是按create_time字段是字符型给出的，如果你的表中此字段是日期型，则进行一下转化