这个SQL语句: SELECT TOP 1 * FROM web_Category WHERE (ID NOT IN
(SELECT TOP 1 id FROM web_Category
ORDER BY id asc)) and family = ',2,' ORDER BY id asc
SELECT TOP 1 * FROM web_Category WHERE (ID NOT IN
(SELECT TOP 2 id FROM web_Category
ORDER BY id asc)) and family = ',2,' ORDER BY id asc
SELECT TOP 1 * FROM web_Category WHERE (ID NOT IN
(SELECT TOP 3 id FROM web_Category ORDER BY id asc))
and family = ',2,' ORDER BY id asc
SELECT TOP 1 * FROM web_Category WHERE (ID NOT IN
(SELECT TOP 4 id FROM web_Category
ORDER BY id asc)) and family = ',2,' ORDER BY id asc
在有些电脑上(SQL SERVER 2005) 查询结果都是一样的, 但是在其他的电脑上(SQL SERVER 2005或者2008)查询结果不同求解决方法(让他们显示结果不同)
(SELECT TOP 1 id FROM web_Category
ORDER BY id asc)) and family = ',2,' ORDER BY id asc
SELECT TOP 1 * FROM web_Category WHERE (ID NOT IN
(SELECT TOP 2 id FROM web_Category
ORDER BY id asc)) and family = ',2,' ORDER BY id asc
SELECT TOP 1 * FROM web_Category WHERE (ID NOT IN
(SELECT TOP 3 id FROM web_Category ORDER BY id asc))
and family = ',2,' ORDER BY id asc
SELECT TOP 1 * FROM web_Category WHERE (ID NOT IN
(SELECT TOP 4 id FROM web_Category
ORDER BY id asc)) and family = ',2,' ORDER BY id asc
在有些电脑上(SQL SERVER 2005) 查询结果都是一样的, 但是在其他的电脑上(SQL SERVER 2005或者2008)查询结果不同求解决方法(让他们显示结果不同)
解决方案 »
- 新手提问
- 多重重复的SQL查询语句如何写?谢谢
- 关于TXT文件导入SQL SERVER的问题
- 求推荐快速入门sql2005教材
- SQL 2005中的自带数据库是什么啊?怎么找到它或添加它?
- 一个SQL查询问题,立即解决,立即给分
- LinkServer数据库,执行删除语句会报错
- 为什么我的SQL Server Agent 无法启动呢?
- 如何刪除時間最晚的記錄?
- 我的Oracle SQL*Plus密码system/managert第一次能用,第二天来就不行了,真奇怪。
- 我不需要把SQL Server 2005上的数据同步到SQL Server 2008上,需要怎么做?谢谢!
- 关于sql server 2005加密的密钥备份
create table [web_Category] (id INT,family VARCHAR(20) NOT null DEFAULT ',2,')
insert into [web_Category](id)
select 1 union all
select 2 union all
select 3 union all
select 4 union all
select 5 union all
select 6 union all
select 7select * from [web_Category]
SELECT TOP 1
*
FROM web_Category
WHERE ( ID NOT IN ( SELECT TOP 1
id
FROM web_Category
ORDER BY id ASC ) )
AND family = ',2,'
ORDER BY id ASCSELECT TOP 1
*
FROM web_Category
WHERE ( ID NOT IN ( SELECT TOP 2
id
FROM web_Category
ORDER BY id ASC ) )
AND family = ',2,'
ORDER BY id ASCSELECT TOP 1
*
FROM web_Category
WHERE ( ID NOT IN ( SELECT TOP 3
id
FROM web_Category
ORDER BY id ASC ) )
AND family = ',2,'
ORDER BY id ASCSELECT TOP 1
*
FROM web_Category
WHERE ( ID NOT IN ( SELECT TOP 4
id
FROM web_Category
ORDER BY id ASC ) )
AND family = ',2,'
ORDER BY id ASC
我得到的结果是不同的。