21,887
社区成员
发帖
与我相关
我的任务
分享mssql+php 问题
SELECT TOP 5 *
FROM label
WHERE (id NOT IN
(SELECT id
FROM (SELECT TOP 0 id
FROM label
WHERE classid = 1
ORDER BY id) AS t)) AND (classid = 1)
ORDER BY id
能在mssql 2000下运行，，可以在php里不可以，，哪位大哥帮帮我啊。
说明：
php里的php_mssql.dll为7.0版本
FROM label
WHERE (id NOT IN
(SELECT id
FROM (SELECT TOP 0 id
FROM label
WHERE classid = 1
ORDER BY id) AS t)) AND (classid = 1)
ORDER BY id
能在mssql 2000下运行，，可以在php里不可以，，哪位大哥帮帮我啊。
说明：
php里的php_mssql.dll为7.0版本
...全文
请发表友善的回复…
发表回复
什么都不能 2007-10-19
- 打赏
- 举报
select * from label where classid=1 limit 0,5
yzxlyd 2007-10-19
- 打赏
- 举报
改成limit操作
SELECT *
FROM label
WHERE (id NOT IN
(SELECT id
FROM (SELECT TOP 0 id
FROM label
WHERE classid = 1
ORDER BY id) AS t)) AND (classid = 1)
ORDER BY id limit 5
SELECT *
FROM label
WHERE (id NOT IN
(SELECT id
FROM (SELECT TOP 0 id
FROM label
WHERE classid = 1
ORDER BY id) AS t)) AND (classid = 1)
ORDER BY id limit 5
yzxlyd 2007-10-19
- 打赏
- 举报
mysql 不支持 top运算符
