oracle sql 常用语句

筛选重号：

select * from [表名]
where telno in(select telno from [表名]
group by telno,推荐类型
having count(*)>1)
order by telno,推荐类型

常见应用：
CREATE TABLE [表名1]AS(
select * from [表名2]
WHERE to_char(oper_date,'yyyymmdd') = to_char (sysdate-1,'yyyymmdd')
);

SELECT b.BRANDCODE_DESC,a.device_number,a.user_no,a.service_dinner,c.comments,a.oper_date,
          CASE WHEN oper_flag =1 THEN '定制'
               WHEN oper_flag =3 THEN '取消'
          END 类型
      FROM   zyq_dxy_a a,
             [表名1] b,
             [表名1] c
             WHERE c.gather_day = to_char (sysdate-1,'yyyymmdd')
       and   b.c.gather_day = to_char (sysdate-1,'yyyymmdd');