现有三个表
Number1(id,name,registerdate)
Number2(id,name,registerdate)
Number3(id,name,registerdate)
要查找这三个表中在2008-01-01后注册的所有人数!
Number1(id,name,registerdate)
Number2(id,name,registerdate)
Number3(id,name,registerdate)
要查找这三个表中在2008-01-01后注册的所有人数!
(select count(*) c1 from number1 where registerdate>to_date('2008-01-01','yyyy-mm-dd')) n1,
(select count(*) c2 from number2 where registerdate>to_date('2008-01-01','yyyy-mm-dd')) n2,
(select count(*) c3 from number3 where registerdate>to_date('2008-01-01','yyyy-mm-dd')) n3,