|
|---|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
