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版本
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