WITH
COUNT_COMMENT AS
(
SELECT
ORDER_NO,
SLIP_COMMENT,
REPLACE(SLIP_COMMENT,",","" ) AS REPLACE_COMMENT
FROM ORDERS
)
SELECT
ORDER_NO AS OD_NO,
SLIP_COMMENT AS COMMENT,
LENGTH(SLIP_COMMENT) - LENGTH(REPLACE_COMMENT) +1 AS CNT
FROM COUNT_COMMENT
ORDER BY
CNT DESC,OD_NO DESC