SELECT *
FROM (SELECT tvoyage0_.voyagekey AS x0_0_, tvoyage0_.vesseleng AS x1_0_,
tvoyage0_.vesselchn AS x2_0_, tvoyage0_.arrive_date AS x3_0_,
tvoyage0_.region AS x4_0_, tvoyage0_.i_voyage AS x5_0_,
tvoyage0_.e_voyage AS x6_0_, tvoyage0_.to_port_chn AS x7_0_,
tvoyage0_.i_e AS x8_0_, tvoyage0_.custom_bh AS x9_0_,
tvoyage0_.wzh AS x10_0_, tvoyage0_.yardman AS x11_0_,
tvoyage0_.wq_name AS x12_0_, tvoyage0_.shipcode AS x13_0_
FROM t_voyage tvoyage0_
WHERE (statue BETWEEN '2' AND '4')
ORDER BY arrive_date DESC)
WHERE ROWNUM <= ?你自己看呢,子表里用这个order by 并无意义。所以oracle认为这句ORDER BY arrive_date DESC)是错的,连带后面的括号也失效了,所以会报少了一个右括号
FROM (SELECT tvoyage0_.voyagekey AS x0_0_, tvoyage0_.vesseleng AS x1_0_,
tvoyage0_.vesselchn AS x2_0_, tvoyage0_.arrive_date AS x3_0_,
tvoyage0_.region AS x4_0_, tvoyage0_.i_voyage AS x5_0_,
tvoyage0_.e_voyage AS x6_0_, tvoyage0_.to_port_chn AS x7_0_,
tvoyage0_.i_e AS x8_0_, tvoyage0_.custom_bh AS x9_0_,
tvoyage0_.wzh AS x10_0_, tvoyage0_.yardman AS x11_0_,
tvoyage0_.wq_name AS x12_0_, tvoyage0_.shipcode AS x13_0_
FROM t_voyage tvoyage0_
WHERE (statue BETWEEN '2' AND '4')
ORDER BY arrive_date DESC)
WHERE ROWNUM <= ?你自己看呢,子表里用这个order by 并无意义。所以oracle认为这句ORDER BY arrive_date DESC)是错的,连带后面的括号也失效了,所以会报少了一个右括号
每页20行记录