摘要: 测试数据create table userTest( id int ,name varchar(20), passwd int, score int, age int);insert into userTest values(1,'小明',111,67,21);ins... 阅读全文
posted @ 2017-08-24 10:35 2637282556 阅读(210) 评论(0) 推荐(0) 编辑
摘要: selectFullDepartmentName, YearBudget , SupplementaryBudget , TotalSum , BudgetDate, case jidu when 'JANUARYBUDG... 阅读全文
posted @ 2017-08-24 10:05 2637282556 阅读(299) 评论(0) 推荐(0) 编辑