°ï¿´Ò»¸öSQL²éѯ½á¹û - MS-SQL Server / »ù´¡Àà

/*
±íÀï3Ìõ¼Ç¼Ƭ¶Î£º
SORDER EDA BUN CUST NOUBA JITU0 APRICE
RR128254 0 1 CSZ003U CSZ004U 62.700 62.10000000
RR128254 0 2 CSZ003U CSZ004U 213.750 62.10000000
RR128254 0 3 CSZ003U CSZ004U 8.550 62.10000000
*/
select case when cust='chf001j'and nouba='chf001j' then ceiling(jitu0*aprice)
  when right(cust,1)='j'and cust<>'chf001j'and nouba<>'chf001j'then round(jitu0*aprice,0)
  else round(jitu0*aprice,2) end
from xract where sorder='RR128254'

--ÕÕÀíÓ¦³öÀ´ round(jitu0*aprice,2)µÄ½á¹û£¬µ«ÊÇÈ´³öÀ´ceiling(jitu0*aprice)µÄ½á¹û£¬Ôõô»ØÊ£¿

---

ÓеãõèõΣ¬²»ÖªµÀɶԭÒò¡£ÎÒÔÚÎÒ»úÆ÷ÉÏûÎÊÌ⣬³öÀ´ÕýÈ·½á¹û¶øÀ´¡£

---

ΪÁËÕýȷ˵Ã÷ÄãµÃµ½µÄ½á¹û£¬½«then ºó¶¼ÓÃ×Ö·û´®ÊÔÊÔ±ÈÈç then 'a' then 'b' else 'c'

---

Äã¿ÉÒÔÕâÑù²âÊÔ£¬¾ÍÖªµÀËü¶ÁÈ¡µÄÊÇÄĸöÖµ

select case when cust='chf001j'and nouba='chf001j' then 'a' when right(cust,1)='j'and cust<>'chf001j'and nouba<>'chf001j'then 'b'
  else 'c' end
from xract where sorder='RR128254'


³öÀ´Ó¦¸ÃÊÇc

---

to 2Â¥£¬ÎÒÊÔ¹ýÁË£¬ÓÃ×Ö·û´®µÃµ½µÄ½á¹ûÊǶԵģ¬µ«Ò»ÓÃÕýʽµÄÓï¾ä¾Í²»ÐÐÁË¡£¼û¹í¡£

---

select 
case when cust='chf001j'and nouba='chf001j' then 'a'
when right(cust,1)='j'and cust<>'chf001j'and nouba<>'chf001j'then 'b'
else 'c' end,
* from xract where sorder='RR128254'

³öÀ´ÊÇc

µ«ÓÃ
select case when cust='chf001j'and