zkwgpp的专栏

  select to_char(apply_date,'yyyy')||'年' ||to_char(apply_date,'mm')||'月'||to_char(apply_date,'dd')||'日'from redemption;   

     SELECT     CASE     WHEN LENGTH(R.CUSTOMER_NAME)>9 THEN '潮宏基'      ELSE TO_CHAR(CUSTOMER_NAME)     END FROM REDEMPTION R 

       select     --姓名（姓名大于四个字的以‘ABC’代替）        case         when length(c.last_name)>5 then 'ABC'       else last_name       end        as moudle       from  table1   case ...

 select sum(p.point) as sum_balan,p.customer    from point_transaction p ,customer c      where p.customer=c.id            group by p.customer      聚合函数 使用group by时候，前面出现的字段，group by 时一定要出现...

     SELECT     CASE     WHEN LENGTH(R.CUSTOMER_NAME)>9 THEN 'ABC'     ELSE TO_CHAR(R.CUSTOMER_NAME)     END FROM REDEMPTION R