2012年12月6日
一条SQL语句-OA
摘要： select t.*,t1.*,t2.* ,t3.* from work_weekly_task_master t, work_task t1 , work_weekly_task_detail t2 ,WORK_MAINTAIN_TASK t3 where t.work_task = t1.work_task_id and t2.weekly_task_master = t.weekly_task_master_id and t3.maintain_task_id = t1.work_maintain_task and t1.work_type = '04' 阅读全文
posted @ 2012-12-06 08:35 微明Axel 阅读(177) 评论(0) 推荐(0)
两条SQL语句
摘要： select count(*) as "所查人数" from (select * from table_a a, table_b b where a.pid = b.pid) t where t.name like '张%' and t.age >= 24 and t.age <= 50;select avg(t1.age) as "所查平均年龄" from (select * from table_a a, table_b b where a.pid = b.pid) t1 where t1.name like '张 阅读全文
posted @ 2012-12-06 08:33 微明Axel 阅读(156) 评论(0) 推荐(0)