--sqlserver 分页
select id,Brand,TradeNum_Month,TradeMun_LastMonth,TradeAmt_Month,TradeAmt_LastMonth,AvgPayment_Month,CollectNum_Month,AuctionNum,ShopNum,OperationDate from hyfx_BrandTradeDistribution where Brand like '%阿%' order by Id offset (2- 1) * 10 row fetch next 10 row only
select id,Brand,TradeNum_Month,TradeMun_LastMonth,TradeAmt_Month,TradeAmt_LastMonth,AvgPayment_Month,CollectNum_Month,AuctionNum,ShopNum,OperationDate from hyfx_BrandTradeDistribution order by Id offset (2- 1) * 10 row fetch next 10 row only
select id,Brand,TradeNum_Month,TradeMun_LastMonth,TradeAmt_Month,TradeAmt_LastMonth,AvgPayment_Month,CollectNum_Month,AuctionNum,ShopNum,OperationDate from hyfx_BrandTradeDistribution where Brand like '%阿%' order by Id offset (2- 1) * 10 row fetch next 10 row only
select id,Brand,TradeNum_Month,TradeMun_LastMonth,TradeAmt_Month,TradeAmt_LastMonth,AvgPayment_Month,CollectNum_Month,AuctionNum,ShopNum,OperationDate from hyfx_BrandTradeDistribution order by Id offset (2- 1) * 10 row fetch next 10 row only