07 2016 档案
摘要:select trunc(sysdate- to_date(to_char(j.create_date,'yyyy-mm-dd'),'yyyy-mm-dd')) 相差天数 from sys_user j where j.id='100008881'
阅读全文
摘要:package com.jy.demo.web; import java.util.Date; public class People { private String name;//姓名 private int age;//年龄 private String email; private Date date; public Date getDat...
阅读全文
摘要:select * from ( select * from (SELECT c.*,row_number() over(PARTITION BY c.reg_channels ORDER BY c.CREATE_TIME DESC) rn FROM app_user c ) where rn=1 )jj where jj.reg_channels='SAPP002'
阅读全文