H happy_hsr Unregistered / Unconfirmed GUEST, unregistred user! 2006-08-14 #1 有一个SQL语句,如果要求根据其中两个栏位的差值做条件得出不同的结果时,要怎样写,如下所示:table1中的m_qty-h_qty,当差值大于0时则用m_qty-h_qty得出一个新栏位mh_qty,如果小于0就当0,怎么用写这个select语句!
有一个SQL语句,如果要求根据其中两个栏位的差值做条件得出不同的结果时,要怎样写,如下所示:table1中的m_qty-h_qty,当差值大于0时则用m_qty-h_qty得出一个新栏位mh_qty,如果小于0就当0,怎么用写这个select语句!
K kk2000 Unregistered / Unconfirmed GUEST, unregistred user! 2006-08-14 #2 select case when m_qty-h_qty > 0 then m_qty-h_qty else 0 end from tb
D dcms Unregistered / Unconfirmed GUEST, unregistred user! 2006-08-14 #5 题目有点问题,不知道是大于等于零呢,还是小于等于零的情况: select field1, field2, CASE type WHEN m_qty-h_qty>0 THEN m_qty-h_qty WHEN m_qty-h_qty>0 THEN 0 ELSE XXXX END AS field3, field4 from Table
题目有点问题,不知道是大于等于零呢,还是小于等于零的情况: select field1, field2, CASE type WHEN m_qty-h_qty>0 THEN m_qty-h_qty WHEN m_qty-h_qty>0 THEN 0 ELSE XXXX END AS field3, field4 from Table
