ÇóÒ»SQLÓï¾ä

with dataTable as (SELECT ROW_NUMBER() OVER (ORDER BY DateTime asc) AS RowIndex,*, a.AcceptMoney - a.ActuallyMoney as Profits from ( select Convert(varchar, ProduceTime, 111) as DateTime , COUNT(orderid) as OrderNumber, SUM(PersonCount) as Number, SUM(Fare) as AcceptMoney, SUM(CustFare) as ActuallyMoney from B_Orders where PromulgatorCode = 1 and DATEDIFF(MONTH, ProduceTime, '2010-3-31 0:00:00') = 0 group by Convert(varchar, ProduceTime, 111)) a) select * from dataTable where 1=1 and RowIndex between @row1 and @row2



ÇóÕâ¸öSqlÓï¾ä²éѯ½á¹ûµÄ×ÜÌõÊý

---

with dataTable as (SELECT ROW_NUMBER() OVER (ORDER BY DateTime asc) AS RowIndex,*, a.AcceptMoney - a.ActuallyMoney as Profits from ( select Convert(varchar, ProduceTime, 111) as DateTime , COUNT(orderid) as OrderNumber, SUM(PersonCount) as Number, SUM(Fare) as AcceptMoney, SUM(CustFare) as ActuallyMoney from B_Orders where PromulgatorCode = 1 and DATEDIFF(MONTH, ProduceTime, '2010-3-31 0:00:00') = 0 group by Convert(varchar, ProduceTime, 111)) a) select count(*) from dataTable where 1=1 and RowIndex between @row1 and @row2

---

ÒýÓÃ

with dataTable as (SELECT ROW_NUMBER() OVER (ORDER BY DateTime asc) AS RowIndex,*, a.AcceptMoney - a.ActuallyMoney as Profits from ( select Convert(varchar, ProduceTime, 111) as DateTime , COUNT(order¡­¡­

up

---

²»ÄÜÕâÑù¼Ó~ÕâÑù¼ÓÁË°ó¶¨Êý¾ÝµÄʱºò»á³öÎÊÌâ

---

ÄÇÑù¾ÍÄò»µ½£¬×Ö¶ÎÃû³Æ

---