SQL 乘法

Question

(select count(*) from t_familymember tf where tf.familyid in (select familyid from  t_publicrentcontract 
where operationtype=3 and familyid in 
(select id from t_familybasicinfo where county=305 and id=808)))*
((select count(*)from  t_publicrentcontract 
where operationtype=3 and familyid in 
(select id from t_familybasicinfo where county=305 and id=808)))这样写哪里错了呢？报SQL命令未正确结束

Answer 1

在最前面加个 select 

Answer 2

Oracle:select (SELECT   COUNT ( * )
   FROM   t_familymember tf
  WHERE   tf.familyid IN
                (SELECT   familyid
                   FROM   t_publicrentcontract
                  WHERE   operationtype = 3
                          AND familyid IN
                                   (SELECT   id
                                      FROM   t_familybasicinfo
                                     WHERE   county = 305 AND id = 808)))
*( (SELECT   COUNT ( * )
     FROM   t_publicrentcontract
    WHERE   operationtype = 3
            AND familyid IN (SELECT   id
                               FROM   t_familybasicinfo
                              WHERE   county = 305 AND id = 808)))
                              
from dual      

Answer 3

你先从你语句的最后看  如果select 出的结果是"集" 那还乘个屁..- -..

Answer 4

mysql select (SELECT   COUNT ( * )
   FROM   t_familymember tf
  WHERE   tf.familyid IN
                (SELECT   familyid
                   FROM   t_publicrentcontract
                  WHERE   operationtype = 3
                          AND familyid IN
                                   (SELECT   id
                                      FROM   t_familybasicinfo
                                     WHERE   county = 305 AND id = 808)))
*( (SELECT   COUNT ( * )
     FROM   t_publicrentcontract
    WHERE   operationtype = 3
            AND familyid IN (SELECT   id
                               FROM   t_familybasicinfo
                              WHERE   county = 305 AND id = 808)))