|
|
|
|
|
|
c***n 发帖数: 921 | 1 How can I get the RNBER2? b is the first number that >= a in the group 2
A1 A2 RNBER1 RNBER2(I want to get)
2008 48(a) 1 1
2008 49 2 2
2008 50 3 3
2008 51 4 4
2008 52 5 5
2008 53 6 6
2009 1 7 7
2009 2 8 8
2009 3 9 9
2009 4 10 10
2009 5 11 11
2009 6 12 12 | S*********N 发帖数: 6151 | 2
go to study the basic syntax.
if you don't understand, you can't do it.
【在 c***n 的大作中提到】 : How can I get the RNBER2? b is the first number that >= a in the group 2 : A1 A2 RNBER1 RNBER2(I want to get) : 2008 48(a) 1 1 : 2008 49 2 2 : 2008 50 3 3 : 2008 51 4 4 : 2008 52 5 5 : 2008 53 6 6 : 2009 1 7 7 : 2009 2 8 8
| z**k 发帖数: 378 | 3 你的问题关系到internal order of the table。Relational DB默认是不保证数据
order的,
所以要解决你的问题,必须先给出order的定义。
【在 S*********N 的大作中提到】 : : go to study the basic syntax. : if you don't understand, you can't do it.
|
|
|
|
|
|
|