Oralce分页

SELECT
*
FROM
(
SELECT
TMP_PAGE.*, ROWNUM ROW_ID
FROM
(
SELECT
A . ID AS "id",
A .bill_notice_no AS "billNoticeNo",
A .bill_lading_no AS "billLadingNo",
A .plan_type AS "planType",
A .out_whouse_code AS "outWhouseCode",
A .out_whouse_name AS "outWhouseName",
A .trnp_mode AS "trnpMode",
A .send_date AS "sendDate",
A .delivy_date AS "delivyDate",
A .freight_mode AS "freightMode",
A .delivy_place_code AS "delivyPlaceCode",
A .delivy_place_name AS "delivyPlaceName",
A .carry_code AS "carryCode",
A .carry_name AS "carryName",
A .car_no AS "carNo",
A .in_whouse_name AS "inWhouseName",
A .driver_name AS "driverName",
A .driver_tel AS "driverTel",
A .driver_id AS "driverId",
A .plan_status AS "planStatus",
A .plan_status_desc AS "planStatusDesc",
A .fac_whouse_flag AS "facWhouseFlag",
A .in_whouse_code AS "inWhouseCode",
A .plan_person AS "planPerson",
A .plan_time AS "planTime",
A .org_code AS "orgCode",
A .org_name AS "orgName",
A .edit_wt AS "editWt",
A .edit_num AS "editNum",
A .plan_wt AS "planWt",
A .plan_num AS "planNum",
A .finish_wt AS "finishWt",
A .finish_num AS "finishNum",
A .plan_amount AS "planAmount",
A .product_ctgr_major AS "productCtgrMajor",
A .submitdate AS "submitdate",
A .pipe_status AS "pipeStatus",
A .fitting_status AS "fittingStatus",
A .bill_notice_no_first AS "billNoticeNoFirst",
A .truck_loading_pipe AS "truckLoadingPipe",
A .truck_loading_fitting AS "truckLoadingFitting",
A .status AS "status",
A .create_by AS "createBy",
A .create_date AS "createDate",
A .update_by AS "updateBy",
A .update_date AS "updateDate",
A .remarks AS "remarks"
FROM
wl_send_main A
WHERE
A .status = 0
AND A .plan_type != 4
ORDER BY
A .create_date DESC,
A .update_date DESC
) TMP_PAGE
WHERE
ROWNUM <= 20
)
WHERE
ROW_ID > 0

巴特西

Oralce分页

最新文章

热门文章