25 Ago 2016 20:09
select count(*) AS QTD FROM
(
select
locador, locatario, sum(rateio) as soma
from hldimrat
group by locador, locatario
) AS resultado
where soma = 100 and locador=3304
25 Ago 2016 21:14
select
locador, locatario, sum(rateio) as soma
from hldimrat
group by locador, locatario
AS resultado
select COUNT(*) as QTD from RESULTADO where soma=100 AND locador=3304
25 Ago 2016 21:26
select count(*) AS QTD FROM
(
select
locador, locatario, sum(rateio) as soma
from hldimrat
where locador=3304
group by locador, locatario
) AS resultado
where soma = 100
26 Ago 2016 11:21
select count(*) AS QTD FROM
(
select
locador, locatario, sum(rateio) as soma
from hldimrat
where locador=3304 AND soma = 100
group by locador, locatario
) AS resultado
26 Ago 2016 11:43
26 Ago 2016 11:47
SELECT name, COUNT(name) AS c FROM orders
GROUP BY name
HAVING c = 1;
select count(*) AS QTD FROM
(
select
locador, locatario, sum(rateio) as soma
from hldimrat
where locador=3304
group by locador, locatario having soma=100
) AS resultado
26 Ago 2016 11:53
select count(*) AS QTD FROM
(
select
locador, locatario, sum(rateio) as soma
from hldimrat
where locador=3304 AND sum(rateio) = 100
group by locador, locatario
) AS resultado
26 Ago 2016 12:00
SELECT name, COUNT(name) AS c
FROM orders
GROUP BY name
HAVING c > 1;
26 Ago 2016 12:18
locador JOAO
locatário JUCA ===> aqui soma 60%
rateio 10% FILHO CHICO
rateio 20% FILHO ANTONIO
rateio 30% FILHA MARIA
26 Ago 2016 12:26
Este exemplo que você postou é a base
26 Ago 2016 13:51
27 Ago 2016 13:59