![](https://img-blog.csdnimg.cn/20201014180756724.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
oracle
瞧风风
我曾经喜欢一个人,我过了很久才忘记ta
展开
-
oracle 选择最新一条数据
根据 time排序 select * from table where rownum=1 ORDER BY CREATED_AT desc原创 2019-11-01 15:44:15 · 842 阅读 · 0 评论 -
oracle根据状态统计近7天的数据
---查询7天的数据 select a.today as "day", nvl(b.general,0) as "general", nvl(b.larger,0) as "larger", nvl(b.great,0) as "great", nvl(b.most,0) as "most" FROM (SELECT to_char (SYSDA...原创 2018-12-17 14:24:31 · 2117 阅读 · 0 评论 -
按照每个分类查询 最近7天 的 4个状态的数据
--按照每个分类查询 最近7天 的 4个状态的数据 select m.section_id as "sectionId", m.section_name as "sectionName", nvl(s.count1,0) as "countWtj", nvl(s.count2,0) as "countDzg", nvl(s.co...原创 2018-12-17 14:24:18 · 148 阅读 · 0 评论 -
数据库时间转化为String比较
//数据库时间转化为String比较 <if test="year !='' and year != null"> AND to_char(CREATE_TIME,'yyyy')=#{year,jdbcType=VARCHAR} </if>原创 2019-01-30 16:23:44 · 585 阅读 · 1 评论