Çóoracle SQLÓï·¨

Èç:


±í½á¹¹£º
  table name :  card

  cardcode  ¿¨ºÅ
  rq          ÈÕÆÚ
  type      ȯÀàÐÍ
    num1    »ý·Ö


Èç¹û·¢Éú»ý·Ö£¬Ð¡ÓÚ200·Ö£¬Ôò·ÅÔÚ200·ÖÒÔÏÂÁÐÖУ¬Èç¹û´óÓÚ200£¬Ð¡ÓÚ500Ôò·ÅÔÚ200-500ÁÐÖУ¬

лл£¡

---

---

ÉÏͼÓÐЩÎÊÌ⣬ÒÔ´ËͼΪ׼£¬Ð»Ð»ÁË£¡

---

¿´²»ÁËͼ£¬²»¹ý¿´ÄãµÄÃèÊö£¬ÕâÑùµÄ¹¦ÄÜÓÃcase when¿ÉÒÔʵÏÖµÄ

---

SQL code:
select cardnode,rq,type,num1,
(case when num1 < 200 then num1 end) "200ÒÔÏÂ",(case when num1 between 200 and 500 then num1 end) "200-500"
,(case when num1 between 500 and 800 then num1 end) "500-800",(case when num1 > 800 then num1 end) "800ÒÔÉÏ"
from card;

---

ÒýÓÃ

SQL code17:36:21 scott@TUNGKONG>select*from card;

CARDNODE  RQ        TYPE            NUM1---------- ---------- ---------- ----------1000129582009-11-11 ¿¨»ý·Ö1601000129512009-11-11 ¿¨»ý·Ö35010001295220?-

GOOD JOB