FlatWang

摘要： ---用逗号隔开查询数据 两种方式 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')... 阅读全文

摘要： 上面为表结构 下面则为 相关函数写法 写这些主要是为了学习下与Oracle的区别 SELECT * FROM STUDENT CROSS JOIN TEACHER;--交叉连接 SELECT * FROM STUDENT S INNER JOIN TEACHER T ON S.TEACHER_ID=T.ID;--内连接 SELECT * FROM STUDENT S LEFT OUTER J... 阅读全文