发表于 2009-1-5 19:48
| 
select case if 鏉′欢杈撳嚭鍒楀
鍙戝竷: 2008-12-05 14:31 | 浣滆: webmaster | 鏉ユ簮: 鏈珯鍘熷垱 | 鏌ョ湅: 30娆
(
id number;
濮撳悕 varchar2(20),
宸ヨ祫 number(10锛2),
銆傘傘
)
鏌ヨ璇ヨ〃 鍒ゆ柇 宸ヨ祫澶т簬10000鐨勪负楂樿柂锛屽惁鍒欎负鏅氾紝鏄剧ず鍑烘潵鐨勫仛娉曟槸锛
select t.*, (case when t.宸ヨ祫 = 10000 then '楂樿柂' else '鏅' end )as 鏄惁楂樿柂 from table1 t
