主页 / 问题 / 968647
Accepted
wq55
Asked:2020-04-12 11:37:11 +0000 UTC2020-04-12 11:37:11 +0000 UTC

oracle建表

  • 772

请告诉我如何构建这个表。

Name (KO No. 1) - 取自表格t_mo字段mo，没有相同的名字

Name2 (MO) - 取自表格t_pet字段otv_kon

格式（空） - 此列将始终为空

格式 2 (1) - 值const

接受(0)

select count(*) 
from t_block t, t_pet p, t_mo w 
where t.id_ger=p.id 
  and p.mo_id=w.mo_id 
  and p.conect_id=5 
  and to_date(t.date_end) between to_date('01.03.2019') and to_date('31.03.2019')
  and p.mo_id =10 
  and p.otv_kon=54001

接受(44)

select count(*) 
from t_block t, t_pet p, t_mo w 
where t.id_ger=p.id 
  and p.mo_id=w.mo_id 
  and p.conect_id=5 
  and to_date(t.date_end) between to_date('01.03.2019') and to_date('31.03.2019')
  and p.mo_id =12 
  and p.otv_kon=54001

已关闭(0)

select count(*) 
from t_block t, t_pet p, t_mo w 
where t.id_ger=p.id 
  and p.mo_id=w.mo_id 
  and p.conect_id=5 
  and to_date(t.date_end) between to_date('01.03.2019') and to_date('31.03.2019')
  and p.mo_id =10 
  and p.otv_kon=54001 
  and p.cause in (22,1)

已关闭(44)

select count(*) 
from t_block t, t_pet p, t_mo w 
  where t.id_ger=p.id 
  and p.mo_id=w.mo_id 
  and p.conect_id=5 
  and to_date(t.date_end) between to_date('01.03.2019') and to_date('31.03.2019')
  and p.mo_id =12 
  and p.otv_kon=54001 
  and p.cause in (22,1)

在此处输入图像描述

sql

1 个回答

  1. Best Answer
    SELECT t_mo.mo, 
       t_pet.otv_kon, 
       '', 
       1, 
       COUNT(*), 
       COUNT(CASE WHEN p.cause IN (22,1) THEN 1 END)
FROM t_block t, t_pet p, t_mo w 
  WHERE t.id_ger=p.id 
  AND p.mo_id=w.mo_id 
  AND p.conect_id=5 
  AND to_date(t.date_end) BETWEEN TO_DATE('01.03.2019') AND TO_DATE('31.03.2019')
  AND p.mo_id =12 
  AND p.otv_kon=54001

    ?

    • 2

相关问题