CrazyMax_zh的博客

SELECTWho_SellOrder.Phone,FROM Who_SellOrder {sqlWhere}ORDER BY Who_SellOrder.Code DESC offset{前面跳过数据量（N(0开始)*PAGESIZe） } ROWS FETCH NEXT {每页容量} ROWS ONLY ;";

select * from SalesManStatisticsInfo where ParentPhone =’’ order by ID offset @pageSize*@pageNum rows fetch next @pageSize rows only

--查询总数select sum(SaleMoneyCount) as currentMonthMoneySumfrom(--按照电话分组 时间排序 select *, ROW_NUMBER () over ( PARTITION by DistributionPhone order by RecordDate desc ) as RowNumber from...

一、统计语句1、–统计当前【>当天00点以后的数据】SELECT * FROM 表 WHERE CONVERT(Nvarchar, dateandtime, 111) = CONVERT(Nvarchar, GETDATE(), 111) ORDER BY dateandtime DESC2、–统计本周SELECT * FROM 表 WHERE datediff(week,[d...

今天写一个查询语句，需要查询CODE、总数量、发货量、未发货量，需要用嵌套查询 在此记录下语法SQL功底有待提升--查询 嵌套select T.Code,T.DeliveryCount,T.TotleCount,T.TotleCount-T.DeliveryCount as NoDelivery from(SELECT dbo.[Order].Code, COUNT(dbo.Cour...