|
¿À³Ê ¿¬·É´ëº° Åë°èÄ¡:
select count(*) from member E, sgroup D where E.dt_birthday between '1980%%%%' and '1984%%%%' and D.id_user=E.id_user;
ÃßõÀÎ ¿¬·É´ëº° Åë°èÄ¡
select count(auser) from
(select m.id_user as auser, substr(m.nm_reg1, 1, 2) as reg from member m,
(select distinct id_propose as propose from member where id_propose not in ('.')) x
where x.propose=m.id_user)
where reg between 20 and 85
|