SELECT DCSEQ, DCA, DCB, DCC, DCD, DCE, DCLOCA, DCDATE, DCHIT,
DCCRNM, RTRIM(DCFILE) DCFILE,
RTRIM(DCTITL) DCTITL, RTRIM(DCCONT) DCCONT,
RTRIM(DCCRDE) DCCRDE, RTRIM(DCBINM) DCBINM,
RTRIM(DCBIDT) DCBIDT, RTRIM(DCBIST) DCBIST,
RTRIM(DCCONT2) DCCONT2, RTRIM(DCCONT3) DCCONT3
from SJSALIB.tbdocupf
WHERE DCSEQ > SELECT (COUNT(*)/10-1)*10+1 FROM SJSALIB.tbdocupf AND DCSEQ < SELECT (COUNT(*)/10)*10 FROM SJSALIB.tbdocupf
ORDER BY DCSEQ DESC, DCA, DCB, DCC, DCD, DCE
where절 안에 이렇게 쓰면 안되나요? (허접질문.)
Error: SQL0120 - Use of column function COUNT not valid. (State:S1000, Native Code: FFFFFF88)
이에러나네요;;;;;; 제발 플리즈~
|