sql
随缘121
这个作者很懒,什么都没留下…
展开
-
两条记录合并一条的 sql
select eu.ID, eu.UID, eu.ID_NO, eu.USER_NICK, eu.USER_NAME, eu.PWD_DIGEST, eu.PWD_SALT, eu.SEX,EMAIL, eu.PHONE, eu.STATUS, eu.USER_TYPE, eu.REG_SRC_ID, eu.USER_LOC, eu.GMT_BIRTH,原创 2016-03-21 12:02:52 · 5428 阅读 · 0 评论 -
sql
select colnum, sum(decode(rnum,1, decode(c.iszy, '1', 1, 0),0)) rnum1, sum(decode(rnum,2, decode(c.iszy, '1', 1, 0),0)) rnum2, sum(decode(rnum,3, decode(c.iszy, '1', 1, 0),0)) rnum3, sum(deco转载 2017-06-29 15:57:07 · 274 阅读 · 0 评论