摘要:
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)