谁能帮我写这个sql语句啊? select count(1) count from tablename group by intime,carnumselect sum(gross) gross from tablename group by intime,carnum 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select sum(1) from (select distinct intime, carnum from tablename) as A 你试试!select a.intime,a.type ,num=sum(carnum) from (select distinct intime ,type,carnum from tablename) agroup by a.intime,a.type 看不太懂:select carnum into table2 from table1 group by carnum where month(outtime)=1select count(carnum) from table2drop table table2 不好意思,上面的有的问题!create table t1 (intime datetime, outtime datetime, carnum int, type char(10))goinsert into t1 values('2004-01-20', '2004-01-25', 1, '玉米')insert into t1 values('2004-01-20', '2004-01-25', 1, '玉米')insert into t1 values('2004-01-21', '2004-01-25', 1, '玉米')select num=sum(carnum) from (select distinct intime ,type,carnum from t1) agodrop table t1num ----------- 2(所影响的行数为 1 行) select intime,carnum,count(*) from tablename group by intime,carnum where DATEPART(month,outtime) = 1 上一语句写错一点,应如下:select intime,carnum,count(*) from tablename where DATEPART(month,outtime) = 1 group by intime,carnum 关于SQL行记录之间的匹配 初学者:解释一下SQL语句 关于数据查询问题 帮忙看看以下sql语句 显示问题 用了存储过程,时间怎么会不对? 如果 存储过程 返回多个结果集,而每一个结果集的结构都不一样,那么怎么访问返回的每一个结果集呢? sql server 2000的个人版和标准版,开发版有什么区别? 急!!!如何在ACCESS中一次性创建十万个空记录。 在SQL Server中,能不能将已定义为varchar(20)的字段,改为varchar(10)? 还是关于同步复制问题 关于建立外键的问题!
(select distinct intime, carnum from tablename) as A
select a.intime,a.type ,num=sum(carnum) from
(select distinct intime ,type,carnum from tablename) a
group by a.intime,a.type
select carnum into table2 from table1 group by carnum where month(outtime)=1
select count(carnum) from table2
drop table table2
create table t1
(intime datetime, outtime datetime, carnum int, type char(10))
go
insert into t1 values('2004-01-20', '2004-01-25', 1, '玉米')
insert into t1 values('2004-01-20', '2004-01-25', 1, '玉米')
insert into t1 values('2004-01-21', '2004-01-25', 1, '玉米')
select num=sum(carnum) from
(select distinct intime ,type,carnum from t1) ago
drop table t1num
-----------
2(所影响的行数为 1 行)
select intime,carnum,count(*) from tablename where DATEPART(month,outtime) = 1 group by intime,carnum