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='2200' ORDER BY CC,sn desc
sub visual

CC

Home > Model > CC
Buy requisition
ÆÇ¸Å¿©ºÎ
Â÷·®Á¾·ù
  • ¸ðµ¨
  • ½Å±Ôµî·Ï
  • ÁÖÇà°Å¸®
  • ¿¬½Ä
  • À̹ÌÁöÁ¤·Ä¹æ½Ä
  • Á¤·Ä¹æ½Ä1
  • Á¤·Ä¹æ½Ä2
'
Â÷·®À̹ÌÁö Â÷Á¾ »ö»ó ÁÖÇà°Å¸® ±â¾î ¿¬½Ä ÆÇ¸Å»óÅ ÃÖÃʵî·ÏÀÏ °¡°Ý Á¶È¸¼ö
µî·ÏµÈ Â÷·®ÀÌ ¾ø½À´Ï´Ù.