W
Size: a a a
2020 February 23
W
select (a.surname||' '||a.lastname||' '||a.patronymic) as fio
from abonents a, tariff_plan t, subscriber_base s, personal_account p
where a.id_abonent = s.abonent_id and t.id_tariff = s.tariff_id and p.contract_id = s.id_contract and t.id_tariff = 4
and (p.date_entry Between current_date - 30 AND current_date)
Group by fio
from abonents a, tariff_plan t, subscriber_base s, personal_account p
where a.id_abonent = s.abonent_id and t.id_tariff = s.tariff_id and p.contract_id = s.id_contract and t.id_tariff = 4
and (p.date_entry Between current_date - 30 AND current_date)
Group by fio
А
select (a.surname||' '||a.lastname||' '||a.patronymic) as fio
from abonents a, tariff_plan t, subscriber_base s, personal_account p
where a.id_abonent = s.abonent_id and t.id_tariff = s.tariff_id and p.contract_id = s.id_contract and t.id_tariff = 4
and (p.date_entry Between current_date - 30 AND current_date)
Group by fio
from abonents a, tariff_plan t, subscriber_base s, personal_account p
where a.id_abonent = s.abonent_id and t.id_tariff = s.tariff_id and p.contract_id = s.id_contract and t.id_tariff = 4
and (p.date_entry Between current_date - 30 AND current_date)
Group by fio
Having count(*)>1
NN
О! Для SQL подскажите хороший конструктор запросов ...
NN
Ещё бы как скачать?
А
NoT NoT
О! Для SQL подскажите хороший конструктор запросов ...
Нет такого понятия как хороший конструктор запросов