sql分页看不懂，请教

wolfs
小邢
等级:

发表于：2008-05-10 13:08:28 楼主

sql = "select * from (select top "+limit+" * from (select top "+(start+limit)+" * from members) m1 order by m1.id desc) m2 order by m2.id asc";

这句sql中的 m1 order by m1.id 是什么意思哦，order by 我知道，关键m1是什么意思哦，文件中没m1,m2这中提示哦

谢谢回答

问题点数：50 回复次数：4 修改删除举报引用回复

sbqcel
空空儿
等级:

发表于：2008-05-10 13:14:201楼得分:20

m1 是 select top "+(start+limit)+" * from members 获得的结果集的别名

修改删除举报引用回复

pt1314917
背着灵魂漫步
等级:

发表于：2008-05-10 13:27:292楼得分:0

SQL code


sql = "select * from (select top "+limit+" * from (select top "+(start+limit)+" * from members) m1 order by m1.id desc) m2 order by m2.id asc"; 

--m1是select top "+(start+limit)+" * from members的表别名
--m2是select top "+limit+" * from (select top "+(start+limit)+" * from members) m1 order by m1.id desc的表别名

修改删除举报引用回复

Limpire
昨夜小楼
等级:

发表于：2008-05-10 13:37:103楼得分:20

sql = "select * from (select top "+limit+" * from (select top "+(start+limit)+" * from members) m1 order by m1.id desc) m2 order by m2.id asc";

(select top "+(start+limit)+" * from members) m1
m1是这个结果集的别名

(select top "+limit+" * from (select top "+(start+limit)+" * from members) m1 order by m1.id desc) m2
m2是这个结果集的别名

修改删除举报引用回复