摘要：---用逗号隔开查询数据 两种方式 select wmsys.wm_concat(name) from table_name; SELECT xType, ListAgg(to_char(City),',') WITHIN GROUP(ORDER BY xType) AS xCity FROM MyTest GROUP BY xType 阅读全文

摘要：select * from T_PRODUCT_CATEGORY where cate_id=(select c.p from (select cate_id,lag(cate_id,1,0) over (order by DISPLAYORDER desc) as p from T_PRODUCT_CATEGORY where PRODUCT_MARK='1' and STATUS='1')... 阅读全文