2011年4月27日
高效的多表分页查询代码
摘要： select *FROM(SELECT id, frmNum, cost_price, wholesale_price, pic, lpic1, shopid, stylename,caizhiname, Row_Number() OVER (ORDER BY id DESC) AS rownumFROM (SELECT Frm.id, Frm.frmNum, Frm.cost_price, Frm.wholesale_price, Frm.pic, Frm.lpic1, Frm.sid AS shopid, FrmStyles.name AS stylename, CaiZhiClass.n 阅读全文
posted @ 2011-04-27 13:40 linjianlong 阅读(319) 评论(0) 推荐(0)