Â÷·®À̹ÌÁö | Â÷Á¾ | »ö»ó | ÁÖÇà°Å¸® | ±â¾î | ¿¬½Ä | ÆÇ¸Å»óÅ | ÃÖÃʵî·ÏÀÏ | °¡°Ý | Á¶È¸¼ö |
---|---|---|---|---|---|---|---|---|---|
µî·ÏµÈ Â÷·®ÀÌ ¾ø½À´Ï´Ù. |
select (case when Is_Sale = 'I' then '1' when Is_Sale = 'C' then '2' when Is_Sale = 'J' then '3' when Is_Sale = 'E' then '4' end) as CC,* from tb_Car where Is_open='Y' AND Is_Sale <>'E' and Category1='2900' ORDER BY CC,sn desc