sql分页

string.Format("select * from (select (row_number()over(order by g.id desc))i,ma.ppbb,m.masterid,ma.MasterAccount,g.*,s.ShopName shopN from guanggaolog g left join Shop s on g.shopid=s.id  left join MemCard m on g.cardid=m.CardID left join master ma on ma.Id=m.MasterID where 1=1  {0})  tb where i between {1} and {2} order by time desc", sbWhere, start, end)

select * from (select (row_number()over(order by g.id desc))i,g.* from guanggaolog g left join Shop s on g.shopid=s.id  left join MemCard m on g.cardid=m.CardID left join master ma on ma.Id=m.MasterID)  tb where i between {1} and {2} order by time desc

select * from (select (row_number()over(order by p.id desc))i,p.*,d.nm from picmusic p left join df d on p.userId=d.id ) tb where i between 1 and 10