hacer subconsulta??

[diegonazho]

Código MySQL:

select calldate ,src ,sum(billsec) , count(accountcode) as todas, count(accountcode) as 'entel'
from cdr 
where src = '77000' and 
calldate between '20110301' and '20110401'  and
 billsec > 0 GROUP BY src DESC
 

miren este codigo funciona impeque, pero quiero que haga lo siguiente

el count(accountcode) me muestra las llamadas funciona ok
y quiero hacer otro count(accountcode) pero que me muestre las llamadas de entel y no me funciona

[Nano_]

Saludos

Cual seria la condición para que muestre las llamadas de entel?

[diegonazho]

mira segun yo... ademas que no recuerdo muchosobre consultas anidadas seria algo asi pero no me funciona

Código MySQL:

SELECT calldate ,src ,  count(accountcode) as todas,accountcode as "entel"
FROM cdr 
WHERE src = '77000'
AND calldate BETWEEN '20110301' AND '20110401'
and accountcode in (select count(accountcode) from cdr where accountcode= 'entel')
 GROUP BY src DESC
 

[Nano_]

Saludos

Prueba de la siguiente manera:

Código MySQL:

SELECT calldate ,src ,  count(accountcode) as todas,(SELECT count(accountcode) FROM cdr WHERE accountcode= 'entel' HERE src = '77000'
AND calldate BETWEEN '20110301' AND '20110401') as "entel"
FROM cdr 
WHERE src = '77000'
AND calldate BETWEEN '20110301' AND '20110401'
GROUP BY src DESC
 

[diegonazho]

Gracias nano me resulto de echo lo modifique a esot y funciona

Código MySQL:

SELECT calldate ,src , count(accountcode) as todas,
(SELECT count(accountcode) FROM cdr WHERE accountcode = 'entel' ) as 'entel' 
FROM cdr WHERE src = '77000' AND calldate BETWEEN '20110301' AND '20110401' and  billsec > 0
GROUP BY src DESC