java6でjsonValidation <dependency> <groupId>com.github.erosb</groupId> <artifactId>everit-json-schema-jdk6</artifactId> <version>1.9.2</version> </dependency> jackson2.6.7 try { BufferedReader reader = new BufferedReader(new FileReader(new File("/Applications/Eclipse_2019-06.app/Contents/workspace/ma…

SELECTSELECT c.id ,to_char(c.xdate, 'FMDD') FROM person a LEFT OUTER JOIN anken b ON a.id = b.personid LEFT OUTER JOIN kobetsu c ON b.id = c.ankenidWHERE -- c.oyako = 0 to_char(xdate, 'YYYYMM') = '201802'

selectselect a.id ,b.date ,b.codefrom person a inner join anken b on a.id = b.personid inner join ( select personid ,max(date) maxdate from anken group by personid )T on b.personid = T.personid and b.date = T.maxdate

select b.id2 ,max(date) ,sum(case when b.oyako=1 then 1 else 0 end) as oya ,sum(case when b.oyako=2 then 1 else 0 end) as kofrom table1 a left outer join table2 b on a.id = b.id2group by b.id2