说明: 1.case 表达式 when 值 then 2.case when 表达式 3.SELECT job,sal, CASE WHEN sal<1000 THEN 0 WHEN sal=1000 THEN sal*0.1 WHEN sal=2000 THEN sal*0.15 WHEN sal>=3000 THEN sal*0.2 ELSE sal END tax FROM emp; <wwq00709> 上传 | 大小:12mb
说明: oracle学习资料pdf SELECT job,sal, CASE WHEN sal<1000 THEN 0 WHEN sal=1000 THEN sal*0.1 WHEN sal=2000 THEN sal*0.15 WHEN sal>=3000 THEN sal*0.2 ELSE sal END tax FROM emp; <wwq00709> 上传 | 大小:4mb
说明: Universal Data Access Components (UniDAC) is a powerful library of nonvisual cross-database data access components for Delphi, Delphi for .NET, C++Builder, and Free Pascal. The UniDAC library is designed to help programmers develop faster and cleane <wangdongxidian> 上传 | 大小:5mb