摘要: 1 select a.* from(select ROW_NUMBER() OVER(PARTITION BY 2 c.task_id ORDER BY c.submit_date DESC) rn, c.task_id, 3 c.submit_date,c.opinion,count(c.task 阅读全文
posted @ 2020-11-19 14:59 leviH 阅读(1964) 评论(0) 推荐(0)
摘要: Select decode(columnname,值1,翻译值1,值2,翻译值2,...值n,翻译值n,缺省值) From talbename Where … columnname为字段名 用法相当于if 判断,if columnname = 值1,则替换为翻译值1. 阅读全文
posted @ 2020-11-19 14:56 leviH 阅读(379) 评论(0) 推荐(0)