这详细的介绍了怎么使用自定义变量
set @rownum:=0;
select disease,rn,@rownum,@rownum:[email protected]+1 as cmt from disease_code
where @rownum <=1
结果:
diseasern@rownumcmt
0020011001
0020031112
总结: 本次查询中,首先执 where ,再执行 select
二、
set @rownum:=0;
select disease,rn,@rownum,@rownum:[email protected]+1 as cmt from disease_code
where @rownum <=1
order by rn
结果:
diseasern@rownumcmt
0020011001
0020031112
0020021223
0020041334
0030012045
0030022156
0010013067
0010023178
0010033289
00400240910
004003411011
004004421112
004001431213
012001501314
008001601415
010001701516
007001801617
011003901718
011001911819
011002921920
011004932021
0060011002122
0050011102223
0050021112324
0050031122425
0090011202526
0130011302627
0140011402728
0150011502829
0160011602930
查询:
set @rownum:=0;
select disease,rn,@rownum,@rownum:[email protected]+1 as cmt from disease_code
where @rownum <=1
order by rn,@rownum
结果:
0020011001
0020031112
总结,第2个例子我现在也不明白,为什么,一个排序的差别,结果有这么大的区别。