如何使用 ORACLE SQL 对特定行值进行操作?
技术问答
68 人阅读
|
0 人回复
|
2023-09-12
|
如何使用 ORACLE SQL 操作特定行值?
! J* a/ E" P9 u& b3 o r这是我的 SQL 语法。# s7 e$ N3 ]5 q
SELECT (BASICPAY SUDANG) FROM( SELECT T2.*,ROWNUM AS RN FROM ( SELECT T.*,(BASICPAY SUDANG) FROM TBLINSA T WHERE SUBSTR(T.SSN,8,1) = ORDER BY BASICPAY SUDANG DESC )T2 )T3WHERE RN = 3UNIONSELECT (BASICPAY SUDANG) FROM( SELECT T2.*,ROWNUM AS RN FROM ( SELECT T.*,(BASICPAY SUDANG) FROM TBLINSA T WHERE SUBSTR(T.SSN,8,1) = 2 ORDER BY BASICPAY SUDANG DESC )T2 )T3WHERE RN = 9结果是:
, c9 L. w* O, s+ y(BASICPAY SUDANG)20700002670000在这里,我们需要找出 207000 和 267000 的区别。
; D/ e( d- E4 P3 v3 z我很好奇如何获得这种差异。7 O: Q* X; f! D" w( N* j/ _
$ k' |& B7 C% d5 B
解决方案: |
|
|
|
|
|