select
*
from
( select
distinct tkcbh0_.KCBHID as KCBHID36_,
tkcbh0_.CKDID as CKDID36_,
tkcbh0_.CKRK as CKRK36_,
tkcbh0_.CREATEDBY as CREATEDBY36_,
tkcbh0_.CREATEDTIME as CREATEDT3_36_,
tkcbh0_.CRKSJ as CRKSJ36_,
tkcbh0_.CRKSL as CRKSL36_,
tkcbh0_.CZR as CZR36_,
tkcbh0_.DElETEDBY as DElETEDBY36_,
tkcbh0_.DELETEDFLAG as DELETEDF6_36_,
tkcbh0_.DELETEDTIME as DELETEDT7_36_,
tkcbh0_.MODIFIEDBY as MODIFIEDBY36_,
tkcbh0_.MODIFIEDTIME as MODIFIED8_36_,
tkcbh0_.RKDID as RKDID36_,
tkcbh0_.WZID as WZID36_
from
t_kcbh tkcbh0_
where
(
tkcbh0_.DELETEDFLAG=0
)
and(
tkcbh0_.WZID=?
)
order by
tkcbh0_.CRKSJ desc )
where
rownum <= ?