select top N时怎么指定按某个字段进行排序？？
换句话说select top 3 * form tb 是按哪个字段排出来的top3？
最为奇怪的是，我的这条语句竟然会返回2条记录，请问有是什么问题引起的？
select top 2 [name] from UserInfo
where [name] not in
(select top 1 [name] from UserInfo order by cn DESC )
order by cn DESC
[解决办法]
"select top 3 * form tb "这也行，高手！
[解决办法]
SELECT TOP 3 * FROM yTB ORDER BY yCOL
[解决办法]
select top 2 [name] from UserInfo
where [name] not in
(select top 1 [name] from UserInfo order by cn DESC )
order by cn DESC
===============================================================
检索出两条没错啊，你仔细看看吧。估计你的头有些晕！
不过检索出两条数据是没错的。
[解决办法]
--try
select ID=identity(int,1,1),[name] into #T
from UserInfo
order by cn DESC
select [name] from #T where ID=2
