语句:
select row_number() over (orderby colum1) seqNo,
colum1
from TB_A
where colum1 = 1
假如表TB_A里是
colum1 colum2 colum3
103 203 303
101 201 301
102 202 302
104 204 304
我想问下这句话抽出来的数据一定是按照colum1排序的么?即一定是
seqNo colum1
1 101
2 102
3 103
4 104
不会是其他顺序的么?例如:
seqNo colum1
1 101
3 103
2 102
4 104是否一定要写成下面这样呢(写明orderby seqNo)?
select row_number() over (orderby colum1) seqNo,
colum1
from TB_A
where colum1 = 1
orderby seqNo
select row_number() over (orderby colum1) seqNo,
colum1
from TB_A
where colum1 = 1
假如表TB_A里是
colum1 colum2 colum3
103 203 303
101 201 301
102 202 302
104 204 304
我想问下这句话抽出来的数据一定是按照colum1排序的么?即一定是
seqNo colum1
1 101
2 102
3 103
4 104
不会是其他顺序的么?例如:
seqNo colum1
1 101
3 103
2 102
4 104是否一定要写成下面这样呢(写明orderby seqNo)?
select row_number() over (orderby colum1) seqNo,
colum1
from TB_A
where colum1 = 1
orderby seqNo
你自己去测试一下就知道了
用
select a.* ,rownum rn
from a
order by a.XX和select a.*,row_number () over(order by a.xx)
from a
两个没什么差别的