怎么在这个查询的基础上进行分页

Question

select * from t (
select a.CDNID AS NODEID,a.SERVID AS SERVID,c.TYPE AS NODETYPE,c.ACTIVE AS

NODE_ACTIVE,a.ACTIVE AS SERV_ACTIVE,
b.IP1 AS WANIP,b.IP3 AS LIP,b.CTRLIP AS CTRLIP,a.KEYID AS KEYID,
a.HASH1_START AS HASH1_START,a.HASH1_END AS HASH1_END,a.STAYPATH AS STAYPATH

from ((tb_store_node a join tb_hosts b) join tb_node_info c)
where ((a.SERVID = b.SERVID) and (c.CDNID = a.CDNID))
)
limit 0,10

这样为什么不行？

Answer 1

不知你用的是什么数据库，临时表的名字应该在后面，如果前面的sql语句能正常执行，那加上limit 0,10是没问题的。

select * from (
select a.CDNID AS NODEID,a.SERVID AS SERVID,c.TYPE AS NODETYPE,c.ACTIVE AS

NODE_ACTIVE,a.ACTIVE AS SERV_ACTIVE,
b.IP1 AS WANIP,b.IP3 AS LIP,b.CTRLIP AS CTRLIP,a.KEYID AS KEYID,
a.HASH1_START AS HASH1_START,a.HASH1_END AS HASH1_END,a.STAYPATH AS STAYPATH

from ((tb_store_node a join tb_hosts b) join tb_node_info c)
where ((a.SERVID = b.SERVID) and (c.CDNID = a.CDNID))
) u
limit 0,10