0
推荐
1053
阅读
SQL 用到的函数
1. DECODE (expression, search, result [, search2, result2]... [,default]) SELECT supplier_name, DECODE(supplier_id, 1000, 'IMB', 1001, 'Microsoft', 1002, 'HP', 'Gateway') result FROM suppliers;2. 增加时间:DATEADD( interval, number, date )S...