總部暢銷
select a.*,decode(flag,1,0,0,1,flag) flag_cn from tab_name a order by flag_cn ;
單店暢銷
select a.*,decode(flag,2,0,0,1,1,2,flag) flag_cn from tab_name a order by flag_cn ;
select a.*,decode(flag,1,0,0,1,flag) flag_cn from tab_name a order by flag_cn ;
單店暢銷
select a.*,decode(flag,2,0,0,1,1,2,flag) flag_cn from tab_name a order by flag_cn ;
select a.*,decode(flag,1,0,0,1,flag) flag_cn from tab_name a order by flag_cn, abc;
單店暢銷
select a.*,decode(flag,2,0,0,1,1,2,flag) flag_cn from tab_name a order by flag_cn ,abc;
總部暢銷
select * from tabname order by decode(flag,'1',-1,flag),abc
單店暢銷
select * from tabname order by decode(flag,'2',-1,flag),abc