在一个表中,我需要查询这表中符合某条件的所有记录的数量,又需要查询某列的值为'0'的列的数量,用一条SQL能否实现?下面是表结构,我需要查APPLICATIONID='0001'的所有记录的数量,在返回的结果中,我还需要查STATUSTIME='0'和STATUSTIME!='0'的所有记录的数量,用一个SQL能否实现?Field Type Collation Null Key Default Extra Privileges Comment
------------- ----------- ----------------- ------ ------ ------- ------ ------------------------------- -------
MASSMSID varchar(50) latin1_swedish_ci YES (NULL) select,insert,update,references
GWSMSID varchar(50) latin1_swedish_ci YES (NULL) select,insert,update,references
SISMSID varchar(50) latin1_swedish_ci YES (NULL) select,insert,update,references
EXTCODE varchar(21) latin1_swedish_ci YES (NULL) select,insert,update,references
DESTADDR varchar(21) latin1_swedish_ci YES (NULL) select,insert,update,references
REQUESTTIME datetime (NULL) YES (NULL) select,insert,update,references
SENTTIME datetime (NULL) YES (NULL) select,insert,update,references
SENTRESULT int(11) (NULL) YES (NULL) select,insert,update,references
SMSSTATUS varchar(20) latin1_swedish_ci YES (NULL) select,insert,update,references
STATUSTIME datetime (NULL) YES (NULL) select,insert,update,references
APPLICATIONID varchar(16) latin1_swedish_ci YES (NULL) select,insert,update,references
------------- ----------- ----------------- ------ ------ ------- ------ ------------------------------- -------
MASSMSID varchar(50) latin1_swedish_ci YES (NULL) select,insert,update,references
GWSMSID varchar(50) latin1_swedish_ci YES (NULL) select,insert,update,references
SISMSID varchar(50) latin1_swedish_ci YES (NULL) select,insert,update,references
EXTCODE varchar(21) latin1_swedish_ci YES (NULL) select,insert,update,references
DESTADDR varchar(21) latin1_swedish_ci YES (NULL) select,insert,update,references
REQUESTTIME datetime (NULL) YES (NULL) select,insert,update,references
SENTTIME datetime (NULL) YES (NULL) select,insert,update,references
SENTRESULT int(11) (NULL) YES (NULL) select,insert,update,references
SMSSTATUS varchar(20) latin1_swedish_ci YES (NULL) select,insert,update,references
STATUSTIME datetime (NULL) YES (NULL) select,insert,update,references
APPLICATIONID varchar(16) latin1_swedish_ci YES (NULL) select,insert,update,references
你这不是逗我呢吗?那查出来的数据不是空吗?