top 4 得到的肯定是<=4的记录数。
declare @a table (id int,name varchar(10))
insert into @a
select 1,'a' union all
select 1,'a' union all
select 1,'a' union all
select 1,'a' union all
select 1,'a' union all
select 1,'a' union all
select 1,'a' union all
select 1,'a' union all
select 1,'a'
select top 4 * from @a
/*
结果
id name
--------------
1 a
1 a
1 a
1 a*/
declare @a table (id int,name varchar(10))
insert into @a
select 1,'a' union all
select 1,'a' union all
select 1,'a' union all
select 1,'a' union all
select 1,'a' union all
select 1,'a' union all
select 1,'a' union all
select 1,'a' union all
select 1,'a'
select top 4 * from @a
/*
结果
id name
--------------
1 a
1 a
1 a
1 a*/
用了TOP 4关键字 肯定只会返回<=4条记录。
sqlserver 我刚刚试了可以
csdn还是人气旺,我刚才去可其它论坛,半天没人回答!