create table TopText(id int,A int,B int);
insert into TopText(id,A,B) values(1,23,15);
insert into TopText(id,A,B) values(2,13,5);
insert into TopText(id,A,B) values(3,31,7);
insert into TopText(id,A,B) values(4,5,27);
insert into TopText(id,A,B) values(5,16,47);
insert into TopText(id,A,B) values(6,22,19);
insert into TopText(id,A,B) values(7,21,13);
select id,top 5(A+B) as C from TopText order by C DESC;--报错
--消息:
--消息 156,级别 15,状态 1,第 1 行
--关键字 'top' 附近有语法错误。
|