求一sql语句

[xuxiaomei2707]

select dtSTime,dtETime,iCount from tLP 查询一个表，表中数据是这样的：
dtSTime dtETime iCount
2014-04-10 2014-04-30 6
2014-05-08 2014-05-14 5
2014-04-10 2014-04-30 1
2014-05-08 2014-05-14 3

第一条和第三条的数据开始时间和结束时间是相同的，数量不同，我想查询的结果是：
dtSTime dtETime iCount
2014-04-10 2014-04-30 7
2014-05-08 2014-05-14 8

相同时间的数量相加

[sedshy]

select dtSTime, dtETime, sum(iCount) as iCount from tLP
group by dtSTime, dtETime

[xuxiaomei2707]

另外补充一下 表中还有一列价格dDoPrice dtSTime dtETime iCount dDoPrice 2014-04-10 2014-04-30 6 500 2014-05-08 2014-05-14 5 20 2014-04-10 2014-04-30 1 300 2014-05-08 2014-05-14 3 400 2014-05-08 2014-05-14 3 0 要判断 (case when tLP.dDoPrice=0 then '小' else '大' end) as cStyle 得到的数据是 dtSTime dtETime iCount cStyle 2014-04-10 2014-04-30 7 大 2014-05-08 2014-05-14 8 大 2014-05-08 2014-05-14 3 小

[向东流]

select dtstime,dtetime,sum(icount) as icount,
case when dDoPrice=0 then '小' else '大' end as cStyle from tLP
group by dtstime,dtetime,case when dDoPrice=0 then '小' else '大' end

[Mr_Nice]

SELECT  dtSTime, dtETime,SUM(iCount) AS icount,(case when tLP.dDoPrice=0 then '小' else '大' end) as cStyle
FROM tLP
GROUP BY  dtSTime, dtETime,case when tLP.dDoPrice=0 then '小' else '大' end

[泡芙小姐1228]

楼上的方法能够实现。学习了 think you