根据多关键字查询

 

SELECT * FROM "PUBLIC"."house_disaster_event" WHERE "disaster_event_name" LIKE '%内蒙古%' AND "disaster_event_name" LIKE '%风暴%';

 

SELECT to_char(disaster_date,'yyyy') areaCode,to_char(disaster_date,'mm') areaName,COUNT(house_damage_id) totalNum FROM house_damage_ledger
WHERE area_code LIKE '15%'
         GROUP BY areaCode,areaName HAVING areaCode='2014'  
         ORDER BY totalNum desc;

 

SELECT * FROM support表名 WHERE CONCAT(NETRAFFIC_TIME, DURATION1, DURATION2, SOURCE_IP, DECODE_POLICY_NAME) LIKE '%ssh%' ;

 

SELECT 
COUNT(case when family_type=1 then 1 end) c1,
COUNT(case when family_type=3 then 1 end) c3,
COUNT(case when family_type=4 then 1 end) c4,
COUNT(house_damage_id) totalNum,
totalNum-c1-c3-c4
FROM "PUBLIC"."house_damage_ledger"
WHERE "area_code" LIKE '35%';

SELECT  SUBSTRING(area_code,1,2)||'0000000000' areaCode,t.name areaName,COUNT(house_damage_id) totalNum ,
COUNT(CASE family_type when 1 then 1 end) c1,COUNT(CASE family_type when 3 then 1 end) c3,
COUNT(CASE family_type when 4 then 1 end) c4,COUNT(CASE family_type when 5 then 1 end) c5,
COUNT(CASE family_type when 6 then 1 end) c6,totalNum-c1-c3-c4-c5-c6 c0,
to_char(disaster_date,'yyyy') theYear  
FROM house_damage_ledger 
LEFT JOIN base_area t ON t.id=SUBSTRING(area_code,1,2)||'0000000000' 
GROUP BY theYear,areaCode,areaName 
HAVING theYear ='2014' ORDER BY totalNum DESC
 

SELECT 
SUM(CASE family_type when 1 then 1 end) c1,
SUM(CASE family_type when 3 then 1 end) c3,
SUM(CASE family_type when 4 then 1 end) c4,
SUM(CASE family_type 
 when 1 then 0
 when 3 then 0
 when 4 then 0
 ELSE 1
 END
) c0,
count(*)
FROM "PUBLIC"."house_damage_ledger"
WHERE "area_code" LIKE '35%';