03 2017 档案

Oracle 按指定顺序排序
摘要：select * from (select 'Nick' as item from dual union all select 'Viki' as item from dual union all select 'Glen' as item from dual ... 阅读全文
posted @ 2017-03-22 19:13 对我有点小自信 阅读(5472) 评论(0) 推荐(0)
oracle删除重复数据，只保留一条
摘要：比如，某个表要按照id和name重复，就算重复数据 如果以id，name和grade重复算作重复数据 注意 min也可以换成max 阅读全文
posted @ 2017-03-07 14:40 对我有点小自信 阅读(2940) 评论(0) 推荐(0)