直接用order by 和top结合的语句就可以实现。
创建表及插入数据:
create table test
(id int,
name varchar(20))
insert i来自nto test values (1,'百度知道团长')
insert into test values (3,'du小智')
insert into test values (4,'du小佑')
insert into test values (6,'du小短')
inse360问答rt into test values (8,'du知了')
insert into test values (2,'李白')
insert into test values (5,'杜甫')
insert into test values (7,'白居易')
insert into test values (9,'孟浩然')
insert into test values (10,'王维')
insert into test values (11,'吕布')
insert into test values (13,'赵云')
insert into test values (14,'典韦')
insert into test values (16,'关羽')
i己欢伯价营明右却nsert into test values (18,'马超')
insert into test values (织题你送山由银12,'孙悟空')
insert into test values (15,'猪八戒')
insert into test values (17,'沙和尚')
insert into test values (19,'唐僧')
insert into test values (20,'白龙马')
insert into test values (21,'宋江')
insert into test values (23,'卢俊义')
insert into test values (24,'吴用')
insert into test values (26,'公孙胜')
insert into test values (28,'关胜')如上,插入25条数据,现在要求按ID排序,并取出ID从小到大的前20条数据,可用如下语句:
select top 20 * from test order by id;结果截图: